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 |
|
hasanali00
Posting Yak Master
207 Posts |
 Posted - 2004-11-29 : 10:00:51
|
| Hi,I wonder if u can helpI have a .dbf file on my machine. I want to put all that data into SQL Server. Is it possible to do so.I believe I can use DTS in SQL Server to do so. However, when I choose 'Import Data' option, I am not sure what to specify in the Data Source field. Can u tell how I can import .dbf file into sql serverregards |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-29 : 13:23:08
|
| What dbms is dbf?Tara |
 |
|
|
hasanali00
Posting Yak Master
207 Posts |
Posted - 2004-11-30 : 05:10:00
|
| Thanks for the response.Initially, I was given a .dbf file, and I was trying to get this file into sql. I was choosing 'Driver do Microsoft dBase (*.dbf)' as the data source, but did not seem to be working.Then I chose 'dBase IV' as the data source, Then I could choose the .dbf file.regards |
|
|
|
scootermcfly
Yak Posting Veteran
66 Posts |
Posted - 2004-11-30 : 06:50:54
|
| That's also the MS Visual FoxPro table extension. So, if that driver doesn't work, try the FoxPro driver.Scooter McFly |
|
|
|
JustDave
Starting Member
2 Posts |
Posted - 2004-12-01 : 14:47:46
|
| Depending on the version of dBase, the older files used to be simple comma delimited text with a header row containing the field names. Have you tried opening this file with a text editor? If it is binary, the results might not be intelegible, but it will tell you the direction to go.If it is readable text, you can get away with changing the file extension and importing it as a text file.HTHJustDave |
|
|
|
|
|
|
|
|
.dbf into SQL Server