Download from SAP too big

[Les Stout]

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

 

[Guest]

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

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]

Thanks very much for the input but i think this is way outa my league,
will limit the download from SAP.

thanks again.

Les Stout

 

[Jim Cone]

Les,

Couple of ways from MS...
http://support.microsoft.com/?kbid=119770
"Text Import Wizard..." (check the xl97 section)

http://support.microsoft.com/?kbid=120596
"Importing Text Files Larger..."

Regards,
Jim Cone
San Francisco, USA

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

 

[Les Stout]

Thanks very much Jim, i have had a look and it looks promising.

Thanks you.

best regards,

Les Stout