Trying to use BCP to export out to a Access table

[jakeir]

Hi,
I want to use BCP to export a table out to MS Access.

I would use something like this to expot out to a text file.
EXEC master..xp_cmdshell'bcp "Select * from test..emp" queryout "c:\dept.txt" -c -T -x'

Does anyone know how to do this to Access instead of a text file?

Also, I do know other ways to do this like SSIS or pass through queries, but I would relly like to do this through BCP if I can.

Thank you

 

[philhege]

http://www.sqlmonster.com/Uwe/Forum...an-SQL-Server-Import-and-Export-Wizard-Access

See the second post.

-------++NO CARRIER++-------