Updating an external table

[Art Vandaley]

Hi,

I would like to change a field of an external table which belongs to a
database located in the server. The address is something like:
\\server\folder\md1.mdb . Let's say value of field1 will be updated. How can
I write the code? Regards.

 

[Douglas J. Steele]

Change how? Do you mean you want to change, say, the name of the field, or
you want to update the data in it?

 

[Art Vandaley]

Update the data in it.

Change how? Do you mean you want to change, say, the name of the field, or
you want to update the data in it?

 

[Douglas J. Steele]

Easiest way would be to create a linked table point to it (through File |
Get External Data | Link Tables. Then, you use the linked table exactly as
if it were in your database.

Other approaches include using the IN clause in your SQL statement or
opening a database object pointing to the other database and using the
Execute method to run your SQL.