Belch
08-23-2007, 07:38 AM
Hi all,
I have some CSV files (large ones, some with one hundred thousand plus rows) and I'm currently importing them using the QueryTables.Add method (which the macro recorder gave me).
I've since seen you can use the Open method and read in a line at at time using Input, but this will probably take far too long with such a big CSV file. The problem I have with using QueryTables.Add is that it seems to leave Names and Connections all over the place.
Is there any other way to import a large text file quickly, or if I was to just remove the Name and Connection added each time I import a file, would that be sufficient?
Thanks,
I have some CSV files (large ones, some with one hundred thousand plus rows) and I'm currently importing them using the QueryTables.Add method (which the macro recorder gave me).
I've since seen you can use the Open method and read in a line at at time using Input, but this will probably take far too long with such a big CSV file. The problem I have with using QueryTables.Add is that it seems to leave Names and Connections all over the place.
Is there any other way to import a large text file quickly, or if I was to just remove the Name and Connection added each time I import a file, would that be sufficient?
Thanks,