Hi
I am looking for some help in automating an import process from excel into acsess.
I currently have a database with 4 tables; DDin, DDOut, CTIn, CTOut. The users of this database receive 3 daily excel files with the corresponding worksheets; DDin, DDOut, CTIn, CTOut. The idea is that the users can click a command button and then be prompted to choose the file (The file location couldd change and the file name will be different each time). When the users choose the file, it will import the cells from each worksheet into the corresponding tables i.e. DDIn worksheet into the DDIn table etc...
Another issue is that we are not in control of the excel sheets they are created by a Third party that we have no control over. I have found that when I was importing them manually it was importing thousands of empty records. I researched this and found that an easy solution is below.
Code:
DELETE * FROM YourTable
WHERE YourField IS NULL;
Can this be added to the same piece of code so it was to run at the end of every import.
Regards
Craig