Need to move a single record from Access to Excel

[msksmack]

Hi,

When I enter a new record into my main table, I'd like figure out a way to copy the data into the table and also append this new record into an existing Excel spreadsheet.

Here's the trick! The spreadsheet I need this data put into already exists and is linked to a dozen other sheets. It's fine if I overwrite the Excel data everytime I link the data from Access, I just need to figure out a way to do this.

Is this a macro? Can I set this all up with a command button? For example, can I set it up so that the user can push a button when on a particular record within my form and the record will be sent to the Excel sheet?

Thanks!

[PianoMan64]

The easiest way to do that would be to add the record to the database, then create and export to an excel spreadsheet that would include the data that you want.

If you need more details, let me know.

Thanks,

Joe P.

[NeoPa]

A short guide :

• Create some SQL filtered for that single record.
• Open a Recordset to that SQL.
• Open Excel (Application Automation).
• Find your way to the first empty line.
• Use CopyFromRecordset method (of your recordset) to transfer the single record across.