Richard Korts
asked on
Export MS Access tables to SQL files
I have a MS Access database on a PC. I want to export some (not all) of the tables in Access to a sql formatted file so I can sub-sequentially import them to a MySQL database on a web server; I know all bout doing the import part.
How can I export data from Access to .sql files?
How can I export data from Access to .sql files?
ASKER
PatHartman
Yes, I can use txt tab delimited. Can you point me in the right direction?
Thanks
Yes, I can use txt tab delimited. Can you point me in the right direction?
Thanks
Use the External Data tab if you want to do this through the GUI. To do it in code, you would use the TransferText Method. Help is very good once you know what you need.
ASKER
PatHartman
See attached. It thinks I want to IMPORT not EXPORT. How do I tell it (Access) that IT want to EXPORT?
export-access.jpg
See attached. It thinks I want to IMPORT not EXPORT. How do I tell it (Access) that IT want to EXPORT?
export-access.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Works great, thanks.
Years ago I worked with Access a lot; seems odd that Export & Import are not "mirrors" of each other.
But it works!
Years ago I worked with Access a lot; seems odd that Export & Import are not "mirrors" of each other.
But it works!
Can't you import .csv or .txt files into MySQL to transfer data? Those are standard and can be created using point and click in the GUI or with a single line of VBA code.