Linked Excel Tables in ACCESS2000 db

D

dpdodson

Problem: Getting Linked Access Table to Update.

Description: The linked Excel table contains data linked
to a 2nd Excel spreadsheet.

When the ACCESS-linked Excel file is manually opened and
saved, the linked data in ACCESS is updated.

When the ACCESS-linked Excel File is programtically (VBA
code) opened, and saved the linked data in ACCESS in not
updated.

Anyone got any ideas on this one.
 

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

Embed the same Excel multiple times 0
Linking data in MS Word into Excel 5
Adding data to MS Access from csv file 0
Consolidation Table from Different Excel Tabs with Different Format 1
Link to excel table which has keys in both row and col headers: isthis possible? 0
nk into onenote 2016 paragraph from excel 2016 cell 0
Autonumber field in Excel that behaves the same as Access 0
Word links to Excel 0

Top