Import file into Excel Sheet

[Jayendra]

Help!

I have a csv file (500,000) lines - I need to import this file into excel sheet 60,000lines per sheet meaning automatically import data from a file into multiple sheets.

Please help me with some good macro to do this job - this is ongoing bcos I get this file every week. HELP HELP HELP!

Thanks in advance

 

[Andrew Poulsom]

See:

http://www.mrexcel.com/board/viewtopic.php?topic=27224&forum=2

 

[Jayendra]

Works like a charm - but the data in the csv is semicolon delimited ( so I changed "Extended Properties=""text;HDR=Yes;FMT=Delimited"";" - but does not delimit.

anyway to get ; to work.

thanks a bunch

 

[Andrew Poulsom]

I couldn't find anything about how to specify the delimiter. It should work without modifying the code. If it doesn't you could use TextToColumns after the import.

 

[Jayendra]

I created system dsn called "importcsv" and changed the code to

oConn.Open "importcsv"

in the importcsv dsn - I choose Custom delimited and used semicolon ; and enable the header row

works like charm - thanks for all the help - this is a great user forum