Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Update Excel file from MS Access?
- Thread starter WaltW
- Start date
WaltW,
Yes, sort of. I'm guessing that you have run into the Updating is not supported by this ISAM or some such message if you try to update infromation in an Excel linked table.
If you up for a little (lot?) of programming in VBA you can use a automation object to open the workbook, navigate to the sheet/cell you need to update, change the cell, save the workbook, then close it.
Interested?
CMP
(GMT-07:00) Mountain Time (US & Canada)
Yes, sort of. I'm guessing that you have run into the Updating is not supported by this ISAM or some such message if you try to update infromation in an Excel linked table.
If you up for a little (lot?) of programming in VBA you can use a automation object to open the workbook, navigate to the sheet/cell you need to update, change the cell, save the workbook, then close it.
Interested?
CMP
(GMT-07:00) Mountain Time (US & Canada)
Hi!
In the database window, click on the table tab and then click the new button. In the popup box choose Link Table. A file browser window will open and at the bottom will be a File Type drop down box, Choose Excel Files. Navigate to your Excel file, select it and click the Link button. Follow the directions in the Wizard from there.
hth
Jeff Bridgham
Purdue University
Graduate School
Data Analyst
In the database window, click on the table tab and then click the new button. In the popup box choose Link Table. A file browser window will open and at the bottom will be a File Type drop down box, Choose Excel Files. Navigate to your Excel file, select it and click the Link button. Follow the directions in the Wizard from there.
hth
Jeff Bridgham
Purdue University
Graduate School
Data Analyst
I'm not sure which version of Access I'm stuck in, I would follow [navy]jerby's[/navy] recommendation since it works and it's easy.
CMP
P.S. I wonder if this was carry-over from the Office 95 days. Anyone remember, can you update a linked worksheet in Access 95? CMP
(GMT-07:00) Mountain Time (US & Canada)
CMP
P.S. I wonder if this was carry-over from the Office 95 days. Anyone remember, can you update a linked worksheet in Access 95? CMP
(GMT-07:00) Mountain Time (US & Canada)
- Thread starter
- #6
Thanks for the replies! I'm using MS Access 2003, and when I link to an Excel file I cannot update it in any way. Supposedly this is a result of one of the SP updates. I'm trying to avoid having to do much programming to get this to work, but if you have something relatively quick and simple, I'd be interested in looking at it. Thanks!
Walt
Walt
Is this anything to do with:
You cannot change, add, or delete data in tables that are linked to an Excel workbook in Office Access 2003 or in Access 2002
You cannot change, add, or delete data in tables that are linked to an Excel workbook in Office Access 2003 or in Access 2002
- Thread starter
- #8
- Status
Similar threads
- Locked
- Question