I am working with Access 2000 and Excel 2000, and have run into a snag
with Linked Tables.
I have a spreadsheet which is set up to import and edit data from a
number of other spreadsheets and create a table of results. This table
is the linked basis for an MS Access table. One of the functions I
need need to control through access is activating the Excel
spreadsheet so that it goes out and gathers the necessary data,
setting it up in a form that I can deal with in Access.
This all seemed quite simple until I got to the next step. I am
triggering the spreadsheet by using "Run App" with Excel and the
spreadsheet names in the argument.
My problem is that I appear to be unable to access the spreadsheet
this way BECAUSE its linked. When change it from linked to import it
works BUT the data I import seems to be the data from the last
compilation of the spreadsheet. If I import twice, then I get the
right data but this just does not feel like the right way to do it.
The problem is NOT in the spreadsheet, which contains the right data
after it has done it processing -- the problem is in the connection
between Access and the Spreadsheet.
Can someone point me in the right direction for triggering the
spreadsheet through Access while at the same time having a inked table
which updates the table in Access!!