Hi Ron,
Things are really ok at this end, i'm working for 3 companies concurrent at the moment. Still doing maintenance on vpmeld :-). Also i am starting a webhosting company at the moment for specialised webhosting (foxpro/westwind is an option ;)

Have you tried good old bcp copy? you can run this from a stored procedure. Search in the books online. this is the fastest method to get data into sqlserver. (we used it at GAK for importing >4 million records in aprox. 5 minutes on a not so fast server)
The only problem with bcp is you need a template or structure file to import.
bcp is faster than the xmlbulkcopy a i recall.
HTH,
Wim.

>Hi Wim,
>
>long time no hear (see). How are you doing?
>I have created the upload with ado but this is very slow when pushing 100,000 records into sql-server. It must be able to import data faster than VFP. We are using a potent 2K server for IIS, SQL-server, VFP-com, Adobe Distiller etc. In the end we generate a pdf-file that is returned to the web-browser.
>
>I have used several techniques but the upload is painfully slow and takes too long to run. I was hoping to find a ´faster´ method. This one looked promissing....but I can´t get it to work.
>
>Are you still working in Amsterdam?
>
>Ron B
>