Import txt file into Access (VBA)

Import a text file into Access 2003 using VBA. Situation: An order log where each line should be imported into a new row in a table. This log contains 4 very similar formats, difference primarily being that some lines in the log has fewer fields, thus populating fewer fields in the table, each line is idenfied with a number for the format (except one number which may represent 2 different formats, this is indicated by an another field). Sometimes fields contain delimiters, this results in more fields. In such cases, skip importing the line in question and output the line to an error table. One of the fields are Linux timestamp, I'd like this to be converted to normal human readble timestamp stored in an additional timestamp field in the table. Import should prevent reimport of the same records, though not important. Nice if the system could import multiple files so I don't need to select one file, import, select a new etc. (mark several files blue in import window). I'll supply some labels for the columns in the table and a sample input file. There's a date field in the file, this should be stored as timestamp field value. Import files may contain 100,000+ records per file. It's important that project is completed on time without significant bugs, i.e. you should test the code before uploading it. Future projects are also of interest. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform XP, VBA, Office 2003