Exporting to Excel

[DreamOn]

i have a access database called Company, with a table called Customers.



and i also have a excel document called Accounts.

i have created a form which gets its information from Customers, how do i export the current record - ONLY First Name and Last Name into the Accounts spreadsheet, into the next available row?

when i try to export it, it exports everything from the form into excel

The reason for this is somebody else created the spreadsheet and when a name is added to the list they will open an account for them, normally it is typied in, but to save time i thought if access had a button to click and export the current records name and place it at the bottom of the list would be faster.

Thanks

-DreamOn

[llkhoutx]

Checkout (1) the TransferSpreadsheet function in Access, and (2) Excel automation.

With automation, you have to determine the row to receive the TransferSpreadsheet export.