Can't import table from excel

[swee]

I have created an xls and its the same format as the table in my db. Same column name and same data type. However, when I try to import the xls to an existing table in my db, there was an error message that says, "An error occurred while trying to import file 'C:\MyDocuments\POSystem_Book.xls'. The file was not imported'". This error does not occur when I import it to a new table. Can anyone help in this? A million thanks in advance.

Regards,
Swee

 

[stephen81]

This is a problem I've also experienced when trying to import to an existing table. I've got around it in the past by importing to a new table, then running an append query to put the data into my existing table.