MS SQL Server ODBC - SqlServer data to Access database

Author

SqlServer data to Access database

mylesr

2005-05-07, 3:23 am

Is there an easy way to read a database table from a SqlServer database and
save it to an Access database? I have tried reading the data into a dataset
(using .NET with C#). This part works fine, but then I can't seem to get the
dataset to update or create a file in the Access database.

Mary Chipman [MSFT]

2005-05-09, 9:23 am

If you're looking for easy, then you can do this from the Access UI
from the Import menu or by writing a couple of queries. You can do it
from SQL Server using DTS. The hard/slow way from .NET would be to
write code to create the table in the Access mdb (Access supports the
CREATE TABLE syntax), create the DataTable in your code, then iterate
through it, executing a separate INSERT statement for each row.

--Mary

On Fri, 6 May 2005 20:42:13 -0700, mylesr
<mylesr@discussions.microsoft.com> wrote:

>Is there an easy way to read a database table from a SqlServer database and
>save it to an Access database? I have tried reading the data into a dataset
>(using .NET with C#). This part works fine, but then I can't seem to get the
>dataset to update or create a file in the Access database.

Sponsored Links