Why would you want use ADO instaed of DTS? It's much slower for that task. Anyway, you can start with http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnfoxgen/html/adojump.asp

>I would like to use OLEDB instead of DTS to import my .DBF into SQL server, I have download the OLEDB from Microsoft, but i'm still confused, Please share with me how to use it.
>
>Let say I would like to import my Vendor.dbf into SQL server into table vendor in Iventory database, how to do it ?