How do I export Access Table to a linked Excel spreadsheet?

[Daryl Austin]

I successfully linked an Excel file into my Access database and using an Update query pull in information to my Quote log table. That works fine. Now I am trying to go the other direction, and use information from my Quote log table in Access to update a different Excel spreadsheet. I created an Update Query using the Access table as my source data (some of it's field) and selected the corresponding Excel fields. It doesn't work though, keeps giving me an error. "Cannot update '(expression)'; field not updateable.

The Excel file I am trying to export to I linked within Access. Can anyone offer some suggestions on how to do this correctly?

Thanks for the help.
D-

[nico5038]

I normally use the docmd.transferspreadsheet command to create a (new) excel workbook with the data.

Idea ?

Nic;o)

[Rabbit]

We would need to see your SQL to be able to offer any assistance.

[Daryl Austin]

Nico
Thanks. I'm very much a novice at the programming stuff but I'll try the transferspreadsheet command.

[NeoPa]

It's also very possible to write data to a linked worksheet from Access. Of course we'd need more detailed information to help with that. TransferSpreadsheet can also be used very successfully, and possibly even more easily, so try that first. You may find that easier and it releases the link after the task is completed too, so will probably give you less issues to deal with.

[nico5038]

Hi Daryl,

Just let us know when you have trouble with the code.
The command is however rather easy to use and by adding the code to the OnClick event of an Export button it just requires one line of code.

Success!

Nic;o)