Import Text File without Page Headers

[David P]

I need assistance importing a user list Text file to a single table in Access 2003 without headers. The Text file has multiple pages with headers and multiple roles per OPER ID.




The table should have the fields of: OPER ID, OPR NAME, DEPT, GROUP, COST CTR, OPR INITIALS, PROFILE ID, and PROFILE DESCRIPTION. As you can see in the image, each OPER ID has multiple PROFILE IDs.

Any suggestions would be appreciated.

[June7]

Open the textfile as an object in VBA and read in each line string individually and process as appropriate.

[orange]

Why are you re inputting data that has been generated/printed from some database/file?

Can you talk to the originator of the report and get the raw data?

[David P]

The report is generated by an outside vendor and the only way they can provide the data is through a text file. Do you have any suggestions?

[David P]

Would you be willing to provide an example? I am somewhat familiar with VBA but not using it to open an object.

Thanks

[orange]

Here is a reference to Vba and recordsets.

Good luck.

[June7]

Also, Bing: Access VBA read write text file

http://stackoverflow.com/questions/1...cters-per-line

http://vbadud.blogspot.com/2007/06/v...h-leading.html