Hi Again all.

I'm trying to maintain a lot of lines of information in an Access database - at the moment i'm updating through an asp-page where i manually has to change the records that i want to change... but with more than 1000 records, i wanted to know if anyone could tell me if it's possible to use an Txt-file or Excel file to automatically update the database through an asp-page?

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.