Importing From Excel

[Guest]

I have an excel spreadsheet that I would like to be able to create every week
and then import it into an existing table in Access. I created the
spreadsheet and successfully imported it as a new table several times,
however, when I would try to import the weekly additions I get an error. Of
course it doesn't tell me what the error is it just says that there was an
error importing. The weekly spreadsheet is in the same format as the
original (i use a macro in excel to make sure it's EXACTLY the same). I
didn't think the macro had anything to do with the error because I can still
import to a new table, just not add to an existing one.
Can someone help me please?

 

[Ron2006]

are you following these rules?

Spreadsheet data that you append to an existing Access table must be
compatible with the table's structure.

Each field in the spreadsheet must be of the same data type as the
corresponding field in the table.
The fields must be in the same order (unless you set the Has Field
Names argument to Yes, in which case the field names in the spreadsheet
must match the field names in the table).

Realize that if you put even just a single space into any column beyond
the last column that was used in the prior import then the import will
fail. That is why I always try to import into a NEW table, and do any
appending with a query that only looks at the fields I want it to.