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 - 2002-10-24 : 08:32:41
|
| murali writes "HiI am having a problem when I import a data from DBF file into SQLserver using DTS.I want do that task without using DSN.When I choose Microsoft Visual Foxpro Driver,it asks me to choose the DSN.Is there anyway I can import DBF file data without using DSN?.Thanks in advanceRegards Murali" |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2002-10-24 : 09:03:54
|
| I think you'll have to use a DSN. You can use a File DSN if you want it to be more portable. |
 |
|
|
simondeutsch
Aged Yak Warrior
547 Posts |
Posted - 2002-10-30 : 11:13:44
|
| Depending on what type of database your .dbf is associated with. If it is a dBase type, you don't need a DSN. Choose your version of dBase from the list, and specify the folder location containing the .dbf files.If it is FoxPro files, you probably must use a DSN, although there are several DSNs that come with Windows for FoxPro files and you probably won't have to make a new one.Sarah Berger MCSD |
|
|
|
|
|
|
Importing DBF file using DTS