So yeah, I've got this Foxpro table. About 180K records. I need to import this table to a SQL Server table, straight shot, 1 for 1. It's basically a reload of the table. We truncate the SQL Server table, and stuff the entire FoxPro table into it. The rub is that right now it's taking about an hour or so. Using VB/ADO to grab Foxpro and stuff into SQL Server. I've been told that this needs to be done in 10 minutes. Does anyone have any tips on how I can achieve this faster?