"Christoph Schmitt" <CS.Schmitt@t-online.de> wrote in message
news:c6u81b$rpj$01$1@news.t-online.com...
> 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
>
>