servers

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
ChristophWhy not consider using DTS to import your Excel data to SQL Server?
Steve
"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
>