Records not getting appended

  • Thread starter Thread starter pra
  • Start date Start date
P

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
 
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
Click to expand...

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.
 
Back
Top