Access and Excel

[veena]

I am working on a project, which requires linkage between excel and
access. I got stuck at a point. I would be glad if someone can help me
out with this issue.

I have linked excel sheets to my access database. I want to create a
user interface in Access. My question is - How can I enter a value in
Access in such a way that it is updated in a particular cell in the
Excel worksheet that is linked to the access database. I am able to
display the excel results in access..but unable to enter values in
access to update in excel.

Is this possible in Access? if not can someone please let me know if
there is an alternative way to do this. Thank You.

 

[Douglas J. Steele]

It used to be you could simply link to an Excel spreadsheet from Access, and
you could update that linked spreadsheet the same as you update any other
table. Unfortunately, Microsoft recently lost a lawsuit which meant that
they were forced to remove that ability.

Your options are to export all of the data to a new spreadsheet (using
TransferSpreadsheet), or to use Automation. Take a look at my July, 2005
"Access Answers" column in Pinnacle Publication's "Smart Access" for a
discussion of automating Excel from Access. You can download the column (and
sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html