Records not getting appended

[pra]

I have a macro that appends an excel file onto an access
database. In the access database, I have 27000 records.
The excel sheet has another 2000.

I have tried these already...
1. The macro append successfully the excel sheet to a
similar blank database.
2. I am manually able to add more records to the access
database with 27000 records.

There are no problems with referential integrity etc...

Thanks

 

[John Vinson]

I have a macro that appends an excel file onto an access
database. In the access database, I have 27000 records.
The excel sheet has another 2000.

I have tried these already...
1. The macro append successfully the excel sheet to a
similar blank database.
2. I am manually able to add more records to the access
database with 27000 records.

There are no problems with referential integrity etc...

Thanks

Could you please post the steps of the macro? Clearly it's got some
error, but without knowing what the macro does it's a bit hard to say
what!

Just FWIW, if I were doing this, I'd use File... Get External Data...
Link (or equivalently, TransferSpreadsheet in code or in macro) to
link to the spreadsheet, and then run an Append query.