importing flat file into Access 2007

[olgolg]

Looking for a little assistance/direction.

I have flat files that contain a header record, multiple detail records and a trailer record and sometimes more than one set of these in each flat file. I need to create a record in a parent table from the header and trailer record information and then move all the detail records into a child table. I have saved Specifications stored for importing the long detail records.

Any help on where to start would be appreciated.

[NeoPa]

If the format is fixed then you will probably need to import the data into a single table and parse the data using queries or code from the table it's been imported into.

The physical import table will probably have to have just a single field which would contain the whole record.

Alternatively, you'll need to process the file I/O yourself in code.