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
Christoph
It's actually easier to work with heterogeneous data using an Access
..mdb than it is to use linked servers. If you haven't gotten very far
in developing the front end in the ADP, I'd recommend switching horses
and using an mdb. You can still link to SQLS tables and views, and
continue to work with external data the way you've been doing it all
along. As long as you keep your FE lean and mean by not fetching too
much data via the linked tables, you should be able to create an
efficient and scalable application with an Access mdb as the FE. I've
never seen the benefit of an ADP since you have to give up so much
flexibility and functionality (like local storage, queries, etc.)
without gaining anything in performance or scalability.
-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446
On Fri, 30 Apr 2004 21:07:31 +0200, "Christoph Schmitt"
<CS.Schmitt@.t-online.de> wrote:

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

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
Christoph
Why 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
>