Importing a .dbf using DTS

[charlise]

Hello Everyone,
I'm trying to import a .dbf file into SQL Server using DTS, but it doesn't seem to be working. Apparently I'm not setting up my datasource correctly because after I set it up it never gives me the option to select the file I'm trying to import. Does anyone have any suggestions or have a better way for me to import a .dbf?

 

[AngelB]

Instead of trying to used the .dbf datasource connection, try using 'Other (ODBC Data Source)' then specifying your DSN in the list provided, along with any relevant login and password information.

Gez

 

[charlise]

Thanks Gez. Now I've specified my DSN, but how do I get to the file I'm trying to import?