Hello there
I didn't use access for long time and got some easy questions.
I created a database with 3 tables.
Every day I need to press a button on a form or something else and select 2 excel spreadsheets.
One excel is for sent table and one for receive table.
Every excel got only one sheet.
The 3rd table I want to use to keep track that no sheet is loaded twice or there are some dates missing
I thought the best parctis is:
1. to load the excels into temp table
2. To check that every row in every sheets beloog only for one day.
3. if yes. go to check if the excel from that day have been loaded
4. if yes. reject and prompt.
5. if not, import it to the right table table by insert sql.
Do you think this is the right way?
Where can I find an example for something I can modifay.
Please advice
Thanks