Overwrite with ODBC link

  • Thread starter Thread starter Gerrym
  • Start date Start date
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?
 
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
 
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.
 
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
 
Back
Top