Import dbase 5 (.dbf) file into MS SQL2000 tables

[Guest]

Hi
I have hard time trying to import some dbase 5 (.dbf) files into MSSQL 2000 tables using ASP.Net/VB.Net. Can anyone please point me to the right direction?
Many thanks,

 

[Mary Chipman]

This isn't really the right tool for the job. However, if you want to
automate the process, you can create a DTS package and execute it from
your VB.NET code. A good resource to get started is
http://www.sqldts.com/default.aspx

--mary

 

[Mary Chipman]

DTS. Managed code isn't really designed to handle data transfers
efficiently.

--mary