Appending records from an imported excel table

[Aniko]

Hi,
I would like to append records to an existing table from
an imported excel spreadsheet.
I found the macro Action "Transfer Spreadsheet" all
right, but I am not sure how to append these records from
the spreadsheet with the same macro to the existing table.
Your help is much appreciated.
Aniko

 

[Ken Snell]

TransferSpreadsheet will not add records to an existing spreadsheet. It will
create a new spreadsheet in the EXCEL file and put the records there. You'll
need to use Automation (use VBA code to open the EXCEL file and write a
recordset's contents into the appropriate cells on the existing sheet).

Or you may be able to use CopyFromRecordset Method in EXCEL (not in ACCESS)
to copy a recordset from ACCESS database into a specified range on an
existing sheet.

 

[Aniko]

Thanks Ken,
What I did was I used the Transfer Spreadsheet action to
get an excel spreadsheet into Access, which created a new
table.
But I could not find out how to have the records in this
new table to append to an existing table in Access
automatically.

But while waiting for reply, I kept reading the newsgroup
and found that if I create an append query, I can drag
this query into the macro and it will run the append
query after the Transfer Spreadsheet action.

This is a really good newsgroup, I am certain to visit
again when having problems.
Best regards,
Aniko

 

[Ken Snell]

My apologies....I've had way too many late nights and I musta been sleeping
when I read your post. I was 180 degrees from what you wanted to do.

I'm glad that you found an answer to your question. Next time, I will
endeavor to be awake when providing an answer!

 

[Guest]

No worries Ken, it was still fantastic to see your quick
reply.
Regards,
Aniko