Linking Access database to an Excel Spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access database in which infomation on trapshooting contestants is
stored. Is it possible to link to an Excel spreadsheet so that when we
update the records in Access, it will automatically update the spreadsheet?
 
Once upon a time, this could be done - you could set up a spreadsheet as a
linked table, and it would update just like a regular linked Access table.
But that ended at about A97 (IIRC). Now, while you can still set up a
spreadsheet as a linked table, it is essentially "read-only"; changing the
data in Access will not update the spreadsheet.

If you want to transfer data from Access to Excel, you'll need to use the
TransferSpreadsheet method, or code it via Office Automation.

HTH,

Rob
 
Rob, thank you for your help. Even though it wasn't the answer I was hoping
for, I can now quit looking to see how to do it. I will now go about things
in a different way. Your assistance is greatly appreciated. -- Rosebud
 
Back
Top