Importing Data into Database

[wvufinaid]

We recently had a form done by a local web company. The information submitted through the form can be downloaded as an Access file.

After I downloaded the database for the first time I added a column where I can add the date when we actually processed the information that was downloaded. The information submitted by users who fill out the form keeps being added to one Access file that I can download. What I want to do is import only the new information from that one large Access file I download without dissrupting the information in the database that I have created on my computer with the information I've downloaded. Hopefully I've made sense. Is this possible?

Thanks,
Jason

 

[The_Doc_Man]

You have to know the date of last import in your "private" database and the database that you download needs to have dates of data entry in it. Then perform your append query based on records occurring after the date of last download.

Alternatively, you need to have a unique record number in the downloaded database and you must track that record number in your private database. Then you just determine the highest number you have in your copy, and only copy the records with higher numbers in the downloaded copy.

 

[wvufinaid]

Thanks for your quick reply! I've just run a test append query it and it did exactly what I wanted.

The only thing I can't figure out (please excuse me, I'm a newbie) is how to perform the append query based on the date.