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.
>
Darn! I just noticed that your method involves using MS Access, which I
don't have installed.

Oh well, back to the drawing board.

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


.