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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 OLEDB Provider strings

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-05-22 : 10:28:05
John writes "Even though DTS includes options for importing various versions of dBase files, I can't for the life of me find out the information I need to access a DBF file programmatically. Specifically what I'm doing is setting up SQLMail to get email with a DBF file attached and then import the data from that DBF into a SQL table using the OPENDATASOURCE command. So I guess what I'm really asking is, how do I use the OPENDATASOURCE command to access a dBase DBF file? I'm running SQL2000 SP2 on Windows 2000 Server (SP2)"
   

- Advertisement -