> call through it from c#

> Now like to connect SQL-Server to a Access-Database (not
> Access to SQL-Server !!!) to get the data using the shown
> statement. Into Access i could create a "linked table", to
> get data from an external database.
> How can I do this at SQL-Server?

"nieurig" <anonymous@discussions.microsoft.com> wrote in message
news:17c201c4bb21$dfacdfa0$a301280a@phx.gbl...
> Hi Folks,
> i need to copy data from a Access-Database to a SQL-Server-
> Database. Using a C#-Programm (reading data with
> OleDBDataReader and writing them with OleDbDataAdapter)
> takes more than 3 hours. I need a quicker solution.
>
> If i copy the data into Access by using
>
> select * into newTable from oldTable
>
> it runs only 1 minute.
>
> Now like to connect SQL-Server to a Access-Database (not
> Access to SQL-Server !!!) to get the data using the shown
> statement. Into Access i could create a "linked table", to
> get data from an external database.
> How can I do this at SQL-Server?
>
> Thanks in advance for any help.
> Niels