SQL Dump

Hi All

Is there any tricks I am missing which would speed up a dump of a VFP table into a SQL table.

I have predifined by SQL statement something like this

"insert into mytable (myfield) values (?m.myfield)"

I am then scanning through the VFP table performing a scatter memvar and then executing the SQL.

It works it just seems to take alot longer than I imagined it would.

Thanks IA

Chris.

--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---