如何将Access数据库表导入SQLServer [英] How To Import Access Data base Tables into SQLServer

问题描述

我想知道如何将Access数据库表导入SQLserver，即:如果Access中有20个表，则仅使用c#代码应将这20个表记录导入sqlserver.

Hi,
I want to know how to import Access Database tables into SQLserver, i.e.: if 20 tables are thier in Access those 20 tables records should be imported into sqlserver Using c# code only.

推荐答案

而不是编写复杂的程序，为什么不尝试使用
SQL Server中的导入选项

在对象资源管理器中，右键单击要在其中导入数据的数据库名称. ...>任务.....>导入数据.........>将会出现Sql服务器导入向导

请按照以下步骤操作，然后您将获得所有表以访问ur SQl服务器数据库.


希望这会有所帮助!!

祝你好运

Instead of writing complex program why dont''t u try to use
Import option in the SQL Server

In object Explorer right click the database name you want to import the data in
...>Tasks.....>Import data.........>the Sql server import wizard will appear

follow the steps and then you get all the tables in access to ur SQl server database.


Hope this helps !!

Best of luck

最好在sql中使用import选项.

Its better to use import option in sql. U an particularly select tables thro'' it.

您好，我从此链接获得了解决方案，但我遇到了一个问题.

将数据从Excel或Access使用以下方式导入到SQL Server TSQL脚本

我收到此错误:

SQL Server阻止访问组件"Ad Hoc Distributed Queries"的语句"OpenRowset/OpenDatasource"，因为此服务器的安全配置已将此组件关闭.系统管理员可以使用sp_configure启用临时分布式查询"的使用.有关启用临时分布式查询"的更多信息，请参见SQL Server联机丛书中的表面区域配置".

Hi i got solution from this link but i am getting one problem.

Import Data to SQL Server from Excel or Access using TSQL Script

this error i am getting:

SQL Server blocked access to STATEMENT ''OpenRowset/OpenDatasource'' of component ''Ad Hoc Distributed Queries'' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of ''Ad Hoc Distributed Queries'' by using sp_configure. For more information about enabling ''Ad Hoc Distributed Queries'', see "Surface Area Configuration" in SQL Server Books Online.

这篇关于如何将Access数据库表导入SQLServer的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！