I can claim no particular expertise with either Access or
Excel; however, we are currently importing data from Excel
Access and in doing so, had the same problem (at least
the same error message) that you are getting.
In our case, I first checked that the .xls data looked
like what Access was expecting. It did.
I then discovered that the .xls column headings had to
precisely match the Access table field names. Even so much
a s a space in one or the other that did not match
resulted in error.
Also found that any hidden or extra columns (even empty)
resulted in error. Once I made sure that what was in
the .xls exactly matched what Access was expecting, then
everything went OK and the .xls data went right in to
Access.
Hope this helps.
-----Original Message-----
I have been struggling with the same problem experienced
by "Bob" in his posting of 4/5. Perhaps this is a problem
associated with Bobs in general. At any rate, I can set
up the access database and import historical sales
figures. The problem occurs when I attempt to import
updated monthly figures into the database. I keep getting
the error message "An error occured while trying to import
file <file name>. The file was not imported." Like the
other Bob, I am capable with Excel, but a novice with
Access. Any suggestions?
