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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-02-01 : 11:13:27
|
| Satyendra writes "How can I export Data Programatically from SQL Server to MS ACCESS file ?I have tried by Exporting Data Programatically with bcp and xp_cmdshell and it is working fine for text file but it is not working for MS Access file. when I given the path name for exporting file is c:\temp.mdb, it is showing data is copied but when i open the file is showing unrecognized file format.Please help me.thanks in advance." |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-02-02 : 13:04:44
|
| You cannot use bcp for exporting to Access, you're ending up with a file with an .mdb extension that is a bcp file not an Access database.Use the Export Wizard or DTS and select Microsoft Jet as the destination. |
 |
|
|
|
|
|
Exporting data to MS Access from SQL Server programmatically