update records in Access 2000

[mynah]

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

 

[mynah]

I just used a cut and past method to get some updated data in, only to find that all my queries now have a mixture of dates instead of from e.g. 1st –7th in now mixes them up? Any ideas?