DTS packages don't have to run on the same server as the target database.
Run the package from any SQL client machine which has access to the source
DBFs.

> VB program that select data from fox pro and insert to SQL Server one
You could build the program in VFP and use a remote view to connect to SQL.
Likely much faster than using VB.

--
David Portas
------------
Please reply only to the newsgroup
--

"Aldemar" <aldemark@hotmail.com> wrote in message
news:478a910.0308301418.3b139cf8@posting.google.co m...
> I have to transfer Fox Pro files (.dbf) from my Web Server into a SQL
> Server database periodically. Since the SQL Server is shared, there
> is no direct access to the files on the Web Server. My hosting
> provider can create a DTS for me but I don't think it will work unless
> the package can access fox files directly.
>
> What is the fastest way to transfer data in this situation? I built a
> VB program that select data from fox pro and insert to SQL Server one
> row at a time. This process is extremely slow. Any ideas?
>
> Thanks!
>
> Aldemar