Linking TXT Files to Access
I have a problem which should be simple.
I have a txt file (exported from oracle) containing data I want to add to access. What I usually did was the follwing:
1. Importing the txt file to Excel,
2. Using the Excel Import text wizard to set the brakes for the columns
3. Sort the data and remove the unwanted "crap-lines/data".
4. Save the file as Excel-Worksheet
5. Linking the file to Access. In access the data in the excel file would be taken, manipulated, and added in the Table
But now I have a problem, the txt file is more than 65,536 lines, which we all know is the maximum number of lines Excel can handle in one sheet.
What to do now? The file is a txt file, so I can perform the Import-File function for txt files. However, the Access Import Text wizard works differently than MS Excel. And I don’t really want to import them to Access, as the first need to manipulated in a Query before written in a table. So I need to link them. Linking them would result in the same pronlem.
Could anybody recommend a Program which is capable of doing the same as Excel Import Text wizard, only with large files? So, editing a txt file in such a way to remove the crap/unwanted data, but keeping the “columns” in the txt file in tact?
Any suggestions would be welcome,