[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 463
  • Last Modified:

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?
0
Richard Korts
Asked:
Richard Korts
  • 3
  • 3
1 Solution
 
PatHartmanCommented:
.sql is not a standard file format.  You're going to need to tell us what you want it to contain.  In any event, since it isn't standard, there is no built in export for it so you would need to write code to make it happen.

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.
0
 
Richard KortsAuthor Commented:
PatHartman

Yes, I can use txt tab delimited. Can you point me in the right direction?

Thanks
0
 
PatHartmanCommented:
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.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Richard KortsAuthor Commented:
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
0
 
PatHartmanCommented:
Sorry, I do mostly imports so that was a reflexive answer.  

To export, right click on the table or query and choose Export and then the file type.  The export dialog will open and you may need to push the "Advanced" button to change certain options.
0
 
Richard KortsAuthor Commented:
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!
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now