Someone else may offer a better solution, but the only ways I have found to
deal with this issue a

1. Use ADO to import the file into a recordset, then use ADO's page size
method to write the data into as many sheets as are needed.

OR

2. Depending upon the data contained in your CSV, you may need to rewrite it
into a new CSV and surround all the fields with double quotes (many times
CSVs are not properly constructed in this manner - and Access often
translates datatypes wrong). If you need to do this, it really runs pretty
fast if you use sequential access (i.e. Open...For Append). Then upload the
CSV file into an Access table. From there, query summarized data back into
Excel.

Hope this helps.

"Les Stout" wrote:

Hi all, i do not know if this is possible, but here goes.... i have a
csv file from SAP which is very big +/- 10 mb !! When i open this file
with excel i lose information. Is it possible with code to automatically
paste the rest to another workbook od sheet ?

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***