Linking Access database to an Excel Spreadsheet

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?
 
R

Rob Parker

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
linking to an Excel spreadsheet 1
Linked Excel spreadsheet to be used as table 3
Access VBA creating an Excel spreadsheet with a total line 5
Access to Excel 2
Excel Access - importing an excel spreadsheet 0
A2003 bringing in data from an Excel spreadsheet 1
Access to Excel link 2

Top