Hi. There are a number of approaches to the import of delimited text into tables, including the use of an import specification with the existing Access text import routines instead of repeated use of the Import Wizard that I guess you are using at present (hence the ton of clicking).
The most flexible approach is to use VB code to open the delimited text file, loop through all records, and extract the fields you require, appending them to a custom table as you go. The coding is not difficult, but without details on the type of delimiting you use and the contents of the exported table I can't provide an example at present.
Please advise the type of delimiting (fixed-width, comma-separated, tab-separated etc), whether or not the field headers are output, the structure of the data, (field names, types in the order they appear in your exported records) and which fields you need imported. Although it is useful to know that the fields you want are numeric it would help to know their names and their start/end positions (if fixed width delimiting is involved) or their sequence within the record (if comma or other character delimited).
-Stewart
12
