Re: Needed: An Efficient, reliable and smart way to copy data from one DB to another


"Hal Rosser" <hmrosser@xxxxxxxxxxxxx> wrote in message
news:plbhf.9624$KP1.1427@xxxxxxxxxxxxxxxxxxxxxxxxx
>
>
> There's an easier way -
> create a DSN for your SQL database
> Then right-click the table in Access and choose 'Export'
> You can export the whole table easily that way.
> I used this method to export tables from Access to mySQL, so I'm sure it
> will also work to MS-SQL.
>
Um, I am using MySQL, not MS-SQL.

I already have a DSN for the Access database. Are you suggesting creating a
DSN for the target MySQL databse also? What is your procedure for importing
the tables into MySQL? Is there a section about this in the MySQL
documentation that I have somehow missed? If so, can you tell me where, in
that voluminous documentation to look.

Thanks,

Ted

--
R.E. (Ted) Byers, Ph.D., Ed.D.
R & D Decision Support Solutions
http://www.randddecisionsupportsolutions.com/
Healthy Living Through Informed Decision Making


.