Import specific data based on value from text file

[chasethewind]

Hello,

I'm not sure where I should start. I want to import only some of the values (based on a given value) from a comma delimited text file to an Excel 2007 sheet. The reason is I have over 1.5 million rows of data and Excel can only handle a little over 1 million rows.

 

[Gruuuu]

Probably the easiest thing to do would be to import the text file into Access as a table, then connect to the database from Excel using MS Query. You can then use SQL to selectively import the data.

 

[SkipVought]

I concur.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[GlennUK]

You could try importing external data by MS Query using the Microsoft Text driver to connect to your CSV ... I haven't got access to Excel 2007 so can't check this or give you the exact commands. Then selectively import.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[SkipVought]

I have used the Text Driver in certain instances. There are some things that you have to do, setting up a SCHEMA.ini file.

http://msdn.microsoft.com/en-us/library/ms709353.aspx

But then your humongus text file can work similar to any other table.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}