converting Mysql to Ms Access and viseVersa

[garfild]

Hi,
Do you know if there's a program that do a conversion between Mysql and Access?
I need to convert 5 tables.
Please advise if you know of a way without the need to pay for it.
Thanks a bunch.
Jo

[bassrek]

I think your best option is exporting each table to a text file and then importing those text files into Access.

In mySQL you can do a select statement into a textfile

http://www.mysql.com/doc/en/SELECT.html#IDX1391

To import into Access, you'd right-click inside of your table area, click 'Import...', and change 'Files of type:' to text files. You'd need to double-check the data types and any relationships you have set up once the data is imported.

[garfild]

bassrek
Thanks for the reply,
youre solution sound good, do you know of a way, an out side user given the text files to be able to insert the data into the Access db without opening the db?
Please advise.



Originally posted by bassrek
I think your best option is exporting each table to a text file and then importing those text files into Access.

In mySQL you can do a select statement into a textfile

http://www.mysql.com/doc/en/SELECT.html#IDX1391

To import into Access, you'd right-click inside of your table area, click 'Import...', and change 'Files of type:' to text files. You'd need to double-check the data types and any relationships you have set up once the data is imported.

[bassrek]

I don't believe you can easily do that without developing or purchasing a utility. Access is very limited when it comes to things like that.

Are there additional tables that exist in the database that you don't want that person to access? If so, you can setup user security in Access. It's a little screwy and I'd recommend making a backup first because you might windup locking yourself out totally (speaking from experience :) ), but it might accomplish what you're looking for.

[garfild]

Hi,
To be more clear I will try to explain what I want to do.
We have a main application running using Mysql and an outside translation application using vb and access db.
We need to create some kind of setup that will take few tables from Mysql into Access, the user will do its translation and then to migrate one changed table from Access back to Mysql.
The user has no knowledge of the Access db he familier with the translation program alone.
I hope its clearer now.
If you have any sugestions, I'll appreatiate.


Originally posted by bassrek
I don't believe you can easily do that without developing or purchasing a utility. Access is very limited when it comes to things like that.

Are there additional tables that exist in the database that you don't want that person to access? If so, you can setup user security in Access. It's a little screwy and I'd recommend making a backup first because you might windup locking yourself out totally (speaking from experience :) ), but it might accomplish what you're looking for.

[scoutt]

no possible way unless they open access and import it into it.

[bassrek]

Is automation the issue? Are you trying to keep the developer from having to manually import the text files each time? If so, you can open a text file inside of VB and you can connect to an Acess database within VB. The developer can modify his VB code to open the text file and connect to the database, then iterate through the text file and insert the data into the Access database. After that, the program would continue on with the translation process.

[scoutt]

from my point of view it would be easier to open access then to have the user open VB and do it. if they have the knowledge to do that then they have access on there computer and they can just import it. faster and easier. but tht is if I understand this thread :)

[garfild]

Thanks guys,
Yep its quite tricky.
I wont put the code to insert data into access from the application because it wont solve the problem of inserting the data back to mysql, I reckond the user will have to put himself into the Access db and do the import/export after all.