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
> [snip]
> 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.
>
>
There is a much easier way. I visited the MySQL site today and found they
have a new migration tool. I used it to transfer the data in a matter of
minutes. Now I'd like to see the source code for that tool so I can see how
they did it so quckly.

Cheers,

Ted

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


.