How to get Access to recognize revised linked table content?

[Larry A]

I have an Excel spreadsheet table defined to Access as a linked table. Even
though I am iteratively repopulating the Excel table conent, Access is only
seeing the initial starting values -- which I am thenh appending over and
over again to another Access table rather than picking up each sucessive new
value set.

I am running the append query from Excel through VBA and DAO. I have tried
refresjing the table definition, but that doesn't help. I have tried
running with the Access database open, but that simply slows the process
down.

Is there a way to get Access to recognize and use revised linked table
values? Thanks in advance. Larry.

 

[Alex Dybenko]

Hi,
perhaps you can try to delete linked and then create it again

 

[Larry A]

Okay, I'll try that. Perhaps the speed penalty won't be too much. Thanks.
I am assuming I can figure out the vba code my setting up first as an Access
macro and then converting to an Access vba module. And then adapt the code
for Excel?

Or can I simply leave as a macro and execute the macro directly from Excel?
And is there an easy three line example of how to do? Thanks.

 

[Alex Dybenko]

Hi Larry,
i think you can make such routine on macros, but but best would be to build
it on VBA, much more control and error handling

 

[Larry A]

Okay, I have working now. My setup was fine all along, except that I had
changed the name of the spreadsheet to which I was linking. So my linked
tables in Access were refering to an older, static template. So of course,
I was getting the same numbers saved over and over.

I have always said that I prefer the simple answer -- even when I've just
made a stupid mistake.

Thanks for the advice. Larry.