Hi, i'm trying to write a macro that obtains data from a huge database extract. The amount of data would easily exceed excel's capabillity so instead of a straightforward extract, i've dumped the info into a text file so i can import in chunks.
Split into groups using fields in col A (fields are either "alpha" or "beta") the data would fit on to a spreadsheet. Can anyone give me the code to only import rows where col A = alpha in a text file.
Thanks Tom Knight.
Split into groups using fields in col A (fields are either "alpha" or "beta") the data would fit on to a spreadsheet. Can anyone give me the code to only import rows where col A = alpha in a text file.
Thanks Tom Knight.