By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,880 Members | 1,416 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,880 IT Pros & Developers. It's quick & easy.

Need to move a single record from Access to Excel

P: 1

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?

Sep 11 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 374
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.


Joe P.
Sep 11 '08 #2

Expert Mod 15k+
P: 31,758
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.
Sep 11 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.