Overwrite with ODBC link

G

Gerrym

Can I overwrite the contents of an existing Table while
importing using an ODBC link
 
D

Douglas J. Steele

I'm not sure I understand your question.

You can create a linked table using ODBC, and you can write an Append query
that uses the data in the linked table to overwrite the contents of another
table. Is that what you had in mind?
 
G

Gerrym

Doug
I was importing using ODBC rather than using Linked
Tables. With Linked tables would there be a danger of
changing the original data in the SYBASE database ?
Gerry
 
D

Douglas J. Steele

Yes, linked tables (usually) are read-write, so you could be changing the
original data.

You can import using ODBC, though, just as easily as you can link. File |
Get External Data | Import, and choose ODBC Databases in the "Files of type"
combo in the bottom right hand corner of the dialog that appears.
 
G

Gerrym

Doug, that is the way I am currently importing manually.
Get External Data | Import, and choose ODBC Databases in
Click to expand...
the "Files of type" What I want to do is put this in a
Macro or VB statement so I can attach it to a button on a
form for the user to run. Can you help with that.
Mank Tks
 
Top