Hi,<BR><BR>I have a source text file that looks something like this:<BR><BR>601-6916~00281~1500.00~04/15/2002~kaiser10~kaiser001~11111~100148926~Consultant Fees<BR>101-9201~00601~2500.00~04/25/2002~kaiser11~kaiser002~22222~100148926~Travel<BR> <BR>Each row is marked by a carriage return and each column by the delimiter "~". This text file can contain a very large number of rows. <BR><BR>The objective is to insert all these rows into a table in the database. <BR><BR>My first [easy] approach was to parse the txt file and loop through it and do a oRs.AddNew on each row. This was simple but takes about 10 secs to insert 5100 rows into the table. So obviously there has to be a better way... :-) <BR><BR>2nd Approach:<BR>I built a recordSet by doing the following:<BR>With oRs <BR>.Fields.Append "acct_no", adChar,10,adfldupdateable<BR>.Fields.Append "exp_code", adNumeric,5,adfldupdateable<BR>.Fields.Append "amt", adNumeric,15,adfldupdateable<BR>.Fields.Append "posted", adChar,10,adfldupdateable<BR>.Fields.Append "inv_no", adChar,15,adfldupdateable<BR>.Fields.Append "vouch_no", adChar,15,adfldupdateable<BR>.Fields.Append "vouch_id", adChar,5,adfldupdateable<BR>.Fields.Append "vendor_id", adNumeric,9,adfldupdateable<BR>.Fields.Append "exp_desc", adLongVarChar,10,adfldupdateable<BR>.CursorType = adOpenKeyset<BR>.LockType = adLockOptimistic<BR>.Open<BR>End With<BR>while parsing the text file I added values into this recordset. All this took about 1.92 secs and now I have a recordset that has about 5100 records. <BR><BR>I need to now stick this recordset into a table. The million dollar question is HOW. I can set the activeConnection but how do I specify what table? Is there a way to specify the table and do an updateBatch using this recordset?<BR><BR>Is there a better way to do this in general? Note: The table is in an Oracle database. <BR><BR>Any help will be greatly appreciated.<BR>Thanks in advance,<BR>Archita. <BR>