For horrible reasons...I need to take relatively large tables from access and insert the values into MS SQL. The process can take as much as 5 minutes to do, and generally hangs the browser.<BR><BR>I'm looking for ways to speed things up. I can't use spaddlinkedserver unfortunetly... I was wondering if I can pass in a recordset to a stored procedure somehow. Or if I can do some type of batch insert (ie, select * from blah --> insert into blah2 *)<BR><BR>Any links/thoughts would be appreciated.<BR><BR>Karl<BR><BR>P.S. - I can't use spaddlinkedserver, or upsizing tools.