importing external data

K

KerryF

I have a table which requires updating monthly with information from 10
employees who do not have Access. In order to ensure the data remained
generic I exported the table to an Excel file which I asked them to complete.
However, now when I try to import it back in, it errors but does not provide
any detail of the error.

I thought it might be due to the version of Excel being used but I've saved
it in other versions with no joy.

Does anyone have a guaranteed way to be able to suck information back in
from an Excel file?
 
A

Arvin Meyer [MVP]

Just a guess, but you may be trying to import data with the same key field
into the original table. To remedy that, import to a new table, then link
the 2 tables on the key field and update the first (original) with the data
from the second (import).
 
Top