Jump to content
xisto Community
Sign in to follow this  
ppj

Mysql And Ms Access

Recommended Posts

If you want to move data from a MySQL database to a MS Access I think the best solution would be to make a SQL dump with MySQL and then run the SQL in Access. But you should be able to use MS Access import function (File -> Get external data (or something like that)) and then select ODBC datasource from the filetype list. You should be able to connect with an external DB if you have defined an ODBC connection (depending a bit on which Windows you are using). I haven't done this in several years, but I remember under Windows98 that you had to define an ODBC connection in your control panel, that might have changed in WindowsXP.Check the MS Access helpfiles and Google around a bit, or if you are just exporting data from MySQL to Access, use an SQL dump.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.