By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,905 Members | 2,083 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,905 IT Pros & Developers. It's quick & easy.

SQL Server to MS Acces

P: n/a
Hello,

I want to know how I can save data from a MySQL server in Ms Acces
format.
My situation:

pc1: a MySQL server running;
pc2: Access running + ODBC MySQL drivers.

I can see the data from the MySQL server in Access. This is a link -
as soon as the connection is down, I don't have the data anymore.

What I want is to save the data from the MySQL server on pc1 as a Ms
Access database on pc 2, essentially changing the linked data to a
static database. Kind of making a backup.

Is there an easy way to do this?

Thanks,

Marc
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Marc wrote:
Hello,

I want to know how I can save data from a MySQL server in Ms Acces
format.
My situation:

pc1: a MySQL server running;
pc2: Access running + ODBC MySQL drivers.

I can see the data from the MySQL server in Access. This is a link -
as soon as the connection is down, I don't have the data anymore.

What I want is to save the data from the MySQL server on pc1 as a Ms
Access database on pc 2, essentially changing the linked data to a
static database. Kind of making a backup.

Is there an easy way to do this?

Thanks,

Marc


You can do a File/GetExternalData/Import (not link) and select your OBDC
source. This will MAKE a table, not link it...IOW if you change the
data, it will not update the ODBC table.

You may want to check out TransferDatabase Method in help. If you want
to send the ODBC data to a text file and then import, see TransferText
method.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.