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 |
|
Wodzu
Yak Posting Veteran
58 Posts |
 Posted - 2007-09-21 : 06:38:58
|
| Hello folks.I need to export data into *.DBF file but I don't know if there is a such possibility via Transact SQL. What I would like to do is:1. Perfom some queires on my MS SQL tables and gather data.2. Create a new Data.DBF file and put previously gathered data there.Thanks for any help. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-21 : 07:10:07
|
| I don't know about actually created a new Data.DBF file, but I would expect that DTS can transfer the data for you.Of if you can create a "linked server", to Data.DBF, then you can just useINSERT MyLinkedServer.MyDatabase.Mytable(...)SELECT ...FROM MyLocalSQLServerTableKristen |
 |
|
|
|
|
|
How to create DBF file via Transact - SQL?