Update Query in Access 2000

[mynah]

Hi.

Having looked at a couple of newsgroups and forums, this one looks about the best.

Could somebody help with this question?

In access 2000 I have a single table called “main” the data was imported from Excel. From “main” a number of queries are generated. Each day about 600 records from an Excel file is to be imported into access from excel, what is the best way to update the information from to the “main” folder in access, with new information from excel.

The information contain the same information and columns. I’m new to access so please explain simply?

Thanks in advance

 

[AgatheB]

Hi Mynah,

Should everything be deleted from Access and then get updated with Excel, or should it be checked record by record an if changed, get updated?

Agathe

 

[mynah]

Total update of records for example 500 records for the 1st May. then another 500 records for the 2nd may

Thanks