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 |
|
lilinikco
Starting Member
28 Posts |
 Posted - 2011-09-12 : 09:01:32
|
| hi all.I want to export query result to DBF file(foxpro) and MDB file(access) IN SQL SERVER 2008 with T-Sql.does bcp support dbf export? does bcp support mdb export?or is there any way for this?please give me a sample code for this.thanks lili@@ |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-12 : 09:13:08
|
| we've had a similar requirement and we made use of ssis for achieving this.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
stansmith
Starting Member
1 Post |
Posted - 2011-10-20 : 06:29:11
|
| You can select your query into some temporary table on a server, and then import this table to a DBF file using DBF Commander (http://elphsoft.com/dbfcommander.html) |
|
|
|
|
|
|
Export Query Result to DBF file(foxpro)