There's nothing to stop you from reading a text file and updating access with it. You'd have a record on each line with the fields separated by tabs. Use Insrt, Mid, and Split commands to parse each line to extract the fields.
If you have the MS Access program, the task is even simpler as you can copy the text/excel file and paste it at the end of the Access Table. If the copied info contains header rows, the names have to match column names in the db. If no header rows, the fields in the records have to correspond to the sequence of the db columns.
Topic Options
Post Options
Thanks(0)
