P
Plim
Guest
Each day I receive a "daily" file in Excel that contains data I must upload to the "master" table. The primary key in both of these would be the telephone number. I can link and Import this daily file each day but I seem to be having trouble constructing an append query. This query should look at the key, or the telephone number, and for each match move the customer’s new data into the master table. I have both tables constructed, dataset are the same (date/time, text and so on) yet when I try to append, I receive an error. Could my query be constructed incorrectly or the data types are not matching. I checked the datatypes and they do look like they match!
Any ideas would be greatly welcomed.
Any ideas would be greatly welcomed.