Link to home
Create AccountLog in
Avatar of brothertruffle880
brothertruffle880Flag for United States of America

asked on

Adding/Updating Excel Worksheets Linked within MS Access

Stupid question?
How come you can't update a worksheet linked to an MS ACCESS database file.
You can update other Access tables, You can updated other companies tables. but NOT Excel worksheets?
This makes no sense whatsoever!
Avatar of duttcom
duttcom
Flag of Australia image

Do you mean why can't you update an Excel sheet from within Access?

I am assuming you are aware that you can at least update an Excel file which is linked to an Access database. Not especially useful if you've gone to all the trouble of making a nice GUI in Access!

I believe Excel files can't be updated from Access because the updating and saving process requires manual intervention, rather than the real-time saving and updating that occurs with databases such as Access or SQL. It makes sense if you think about the fact that Access does not prompt you to save your work, whereas Excel does.

Oddly though, it is possible to update an Excel file from a data integration project in BIDS.
Avatar of brothertruffle880

ASKER

Yes.  that's what I mean.  I'm in Access database "A" and have a link to an excel worksheet "B"   I can look at the worksheet but I can't updated it, add records, etc.
ASKER CERTIFIED SOLUTION
Avatar of duttcom
duttcom
Flag of Australia image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account