| View previous topic :: View next topic |
| Author |
Message |
bazianm
Newbie
Joined: 23 Dec 2009
Posts: 3
|
 Posted: Wed Dec 23, 2009 6:03 am Post subject: SCRIPT 'filename' not working? |
 |
|
Hi all,
I have an access MDB that I need to convert to MySQL. I do not have access. I figured that I could open it in Base and work with it that way but I have run into a roadblock. I am guessing that the answer will be "You can't do that" but I thought I would ask given that I am fairly new to OpenOffice.
According to posts I have seen, I can open a SQL window and just issue the command SCRIPT 'filename' and base will generate a SQL Script. It doesn't seem to work in this setup. Is it because I am not using a BASE database but am connecting to an Access mdb?
Does anyone have any suggestions on how I can do this (without having to manually recreate the structures in MySQL?)
Thanks |
|
| Back to top |
|
 |
Sliderule
Super User
Joined: 29 May 2004
Posts: 2476
Location: 3rd Rock From The Sun
|
| Posted: Wed Dec 23, 2009 8:25 am Post subject: |
|
|
bazianm:
You asked:
| bazianm wrote: | | Is it because I am not using a BASE database but am connecting to an Access mdb? |
The answer is, the SCRIPT 'filename' is a command ONLY recognised by the HSQL database engine.
HSQL is the 'default' database engine used by OpenOffice Base. If however, you are 'connected' to a different database engine from Base, such as Microsoft Access, you can only use the commands that database engine, via the Connection . . . for example, ODBC, JDBC etc offers.
You said: | bazianm wrote: | | I do not have access. |
You might want to try to try to 'convert' it to a Comma Separated Values file ( CSV ) from a site such as this ( or any other tool that can convert from .mdb to a file format you want ):
http://media-convert.com/
Where you can convert FROM Microsoft Access, to Microsoft Excel, open the Excel file in OpenOffice Calc, and, save the Access Tables as CSV ( Comma Separated Values ) file(s) that can be used by MySQL.
Another Alternative:
Read the information in the link below, with a detailed explanation by Sliderule on using a LINK to an Access database file to create a CSV file:
http://www.oooforum.org/forum/viewtopic.phtml?t=77347
I hope this helps, please be sure to let me / us know.
Sliderule
Thanks to add [Solved] in your first post title ( edit button ) if your issue has been fixed / resolved. |
|
| Back to top |
|
|
bazianm
Newbie
Joined: 23 Dec 2009
Posts: 3
|
| Posted: Wed Dec 23, 2009 9:26 am Post subject: |
|
|
Thank you for your reply.
Getting the data into CSV is not the problem. I was hoping to get the schema scripted so I did not have to recreate the structure... |
|
| Back to top |
|
|
Sliderule
Super User
Joined: 29 May 2004
Posts: 2476
Location: 3rd Rock From The Sun
|
|
| Back to top |
|
|
|
