Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening CSV file with 69000 + rows in Excel using VBA
Hi all,
I have to open csv files with possibly more than 65000 rows of data in them, and all the rows greater than 1 worksheet have to be put on the next sheet...when that is full I have to add another sheet and so on... Due to the limitations of Excel, I can't even tell the text Import (Querytables) method to start at row 65000 as the textFileStartRow parameter is supposed to be an integer (DOH !) - who came up with that one? So, what is the best option, open the files using OLEDB Text Provider in ADO and load from recordset to read them in chunks of 65000 odd records, or is there a better way? Or should I use the Textfile Import Method, and read it in in chunks of say 30000 by setting the textFileStartRow property to current Value + 30000 for each iteration until completed? thanks for any help or ideas or sympathy... Philip |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opening a file in Excel starts application but dose not open file | Excel Discussion (Misc queries) | |||
Opening file cause rows to lose | Excel Discussion (Misc queries) | |||
Opening file in Excel 2003 opens multipule instances of same file | Excel Discussion (Misc queries) | |||
opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
Error:Invalid File format,while opening an Excel Template file | Excel Programming |