Why is this so?

[AccessKid]

When I am importing xls files into Access new table, there is no error but when I do it into an existing table, the process always end up in an error message that says :

"An error occured trying to import file....The file was not imported."

Has anybody encountered this before?

Thanks.

 

[Hayley Baxter]

The error can occur if there is a space preceding one or more of the field names in the spreadsheet you are trying to import, however I would have thought that you would still get the error while attempting to import to a new table as well as an existing table.

It may be worth opening the spreadsheet in excel firstly to see if there are any leading spaces in the field name(s) and if so removing them and try the import again. Also ensure that the data types are the same as that of your existing table, this may be why you can import to a new table but not an existing table.

Hay

 

[AccessKid]

Thanks. I actually checked the column headings of the spreadsheet and found them not in same sequence with that of the destination table. After I corrected that, it went ok.