How to export DataTable to VFP table?

microsoft.public.dotnet.framework.adonet

2 Dec 2005 1:22 AM

Gordon Lau

Hope someone can help me on this. How do I export a DataTable to a VFP table? My app creates a new DataTable with many rows (could be a half a million rows). I want to save/export the DataTable to a new VFP table. Tried creating a new VFP table and using the insert/update commands (used the OleDbCommandBuilder to automatically generate them for me) to add rows to it but it is WAAY too slow (took over 7 minutes just for 150,000 rows). I'm not updating an existing table. I want to export the results my app produced to a new table. Any ideas?

Thanks,
Gordon -- Gordon Lau ------------------------------------------------------------------------ Gordon Lau's Profile: http://www.hightechtalks.com/m410 View this thread: http://www.hightechtalks.com/t2299513