而不是编写复杂的程序，为什么不尝试使用
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.