Text file too big

[sarlo00]

I know this is not strictly an Access question, but it does relate. I have a CD with four years of claims in one huge file. I need to test these claims against an existing Access database with the same claims by month. The four year file has added fields and I want to check that there was no change in the already existing fields. Is there any application or method to get small chunks of the CD file into Access? or even a text file? The file on the CD is too big for me to open with WordPad. Any help would be appreciated. Thanks, Brian

 

[SydneyGeek]

How is the text file delimited? If it's commas or tabs, copy to hard disk.
In Access, File | Get External Data | Import
Follow the prompts, putting data into a new table.
Now you should be able to run some comparisons in Access.

Denis

 

[sarlo00]

The file is tab delimited but too large to open in Access or WordPad or any application that I currently have on my harddrive. Is there some way to partition the file into smaller files once it is saved to my harddrive?