Overwrite with ODBC link

[Gerrym]

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

 

[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?

 

[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

 

[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.

 

[Gerrym]

Doug, that is the way I am currently importing manually.

Get External Data | Import, and choose ODBC Databases in

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

 

[Douglas J. Steele]

Do it manually, and then look in the Connect property of the linked table to
see what's required. Take a look at
http://www.mvps.org/access/tables/tbl0010.htm at "The Access Web" for one
way to relink ODBC tables through code.