sql server new users: Hi,

I have some data in another database which I need to be able to query
periodically and import new records into my SQL Server database.

At present I've got an access project which has linked ODBC tabels from this
external database and from SQL Server and manages the transfer.

What I'd like to do is skip that Access step and link an external table into
SQL Server instead. How does one do that? (I'm using MSDE, will be going up
to SQL Server 2000 once development is complete).

Thanks in advance for any help.

regards,
Dave

Hi,

I found stuff on Linked Servers. The link seems to be fine, it's just a
question of how to make the data available to queries in my SQL Database.

I can run a query against it
SELECT * FROM
LINKEDBASE...tblNewData

but I can't save the view (Error:"ODBC Error: ... MSDTC on server... is
unavailable")

Hmmm.

regards,
Dave

"David Alger" <dave@nospam.poo> skrev i meddelandet
news:%23QVCwlXSFHA.2964@TK2MSFTNGP15.phx.gbl...
[quoted text, click to view]