Update FROM a Linked Table

[Paul Hammond]

I have a table in an Access database that I want to update from a linked text
file. The common field is Account which I link in the query and I want to
take information from the linked text file (a very large file I don't want to
import) and update a field in the internal table.

I get the standard messages "Updating data in a Linked table is not support
in this ISAM".

Well, I'm not trying to update the linked table. It seems like there should
be a way to do this. Is there?


TIA
Paul Hammond
Richmond, VA

 

[Dave Patrick]

This article may help.

http://support.microsoft.com/?scid=kb;en-us;824159&spid=2509&sid=50

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
|I have a table in an Access database that I want to update from a linked
text
| file. The common field is Account which I link in the query and I want
to
| take information from the linked text file (a very large file I don't want
to
| import) and update a field in the internal table.
|
| I get the standard messages "Updating data in a Linked table is not
support
| in this ISAM".
|
| Well, I'm not trying to update the linked table. It seems like there
should
| be a way to do this. Is there?
|
|
| TIA
| Paul Hammond
| Richmond, VA

 

[Paul Hammond]

Yes, that would work, but I don't want to import 100,000 records into a table
once a week just to update a few hundred. I already have anothe work around
which I can use. I guess this is just a limitation of the program.

Paul

__________________________________________________-