Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
itmasterw
Yak Posting Veteran
90 Posts |
 Posted - 2010-11-15 : 10:04:58
|
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 anoyone know how to do this to Access instead of a text file?Thank you ITM |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2010-11-15 : 10:57:25
|
| Would it not be better to create a simple SSIS package to transfer the data via a ODBC connection?Otherwise i'd look at using the openrowset command to connect to the Access Db and then run an insert statement |
 |
|
|
itmasterw
Yak Posting Veteran
90 Posts |
Posted - 2010-11-15 : 11:39:44
|
| Hi,Thanks for getting back to me. But as you can see, in the above statement is just a single and very short line of code, and anything that you would do in SSIS would be more involved. I would be interesed in using openrowset but I would not know how to do that either. Would you be able to show me an example? Thank youITM |
|
|
|
|
|
|
Export otu to MS Access usin BCP