How do I export MS SQL table to MS Access table

[faamugol]

hi,

I need to export MS SQL table to MS Access table without copying record by record as I have a table of 5.000.000.
how can I do:

Select * from my_tableSQL
Insert into my_tableMSAccess

Thanks in advance

[silverbullet24]

do you have access to enterprise manager so you can export them to a text file and then import it into access?

[russell]

use dts

[metalman3d]

do you have access to enterprise manager so you can export them to a text file and then import it into access?

I'd say that's the easiest way to go. If you don't have enterprise manager, just do a quick script that spits out all the fields in asp as a comma delimiated list, copy and paste to a text file and upload that.

[russell]

dts is easist, fastest (by far)

if u don't have EM then have to do something else

[chrismartz]

Could map the access table as a mssql table. Then use sql enterprise manager to select what you want, then insert them into the access connection.