Linked Servers Access-Project

[Christoph Schmitt]

Hi,
i have several questions, because i'm quite new to SQL-Server and Access
Projects. Till now i only worked with Access.MDB's

i created a new access project and have my database on SQL-Server. I see all
tables in my access-project and can work with them.

Now i need data from 1 excel file and data from an interbase database.

As far as i understand the SQL-Server documentation, this can be done with
linked servers. So i tried to create a new Linked Server for my excel file.
Somehow i must have been doing well because when i tried a query from Query
analyzer i saw the excel data.

When right clicking the linked Server e.g. "XLSSVR" i receive an error: 823,
which i don't understand.

My questions are:
How can i use this linked server from my access project? In other words how
can i access the data from this server?
Do i have to build something on the SQL-Server first, which i could then see
as a view or table in my project or how does that has to be done?

Many thanks for any help!
Regards
Christoph

 

[Brian M. Sockey]

If you've got a query working from Query Analyzer, then you can use the
exact same query from a view or stored procedure to see the Excel data in an
Access project. Linked server data doesn't show up the tables area like it
does in an mdb file.

Brian M. Sockey
www.farsightsolutions.com