您可以在Access中导入MSSQL数据.有关更多信息:

You can import MSSQL Data in Access; More info on: http://office.microsoft.com/en-us/access-help/import-or-link-to-sql-server-data-HA010200494.aspx

更新:

或者，您可以使用sqldataadapter选择所有表以将所有内容存储在数据集中，请参见:

Alternately you can select all tables using sqldataadapter to store everything in a dataset, see: Obtaining a dataset from a SQL Server database

从那里可以将数据集另存为访问数据库文件，请参见: C#访问数据库的数据集

From there on you can save the dataset as a access database file, see: C# Dataset to Access DB

也许这更符合您的问题.

Maybe this is more inline with your problem.