您是否尝试过

Have you tried

SELECT * INTO NewTable FROM existingdb.dbo.existingtable;

ADO.NET的批量复制功能可以帮助您了解一下:

http://msdn.microsoft.com/en-us/library/s4s223c6.aspx [ ^ ]

http://www.c-sharpcorner.com/UploadFile/mahesh/BulckCopyAdoNet2008192005135138PM/BulckCopyAdoNet20.aspx /a> [ ^ ]

Bulk Copy feature of ADO.NET might help you take a look at that :

http://msdn.microsoft.com/en-us/library/s4s223c6.aspx[^]

http://www.c-sharpcorner.com/UploadFile/mahesh/BulckCopyAdoNet2008192005135138PM/BulckCopyAdoNet20.aspx[^]

如果要将Ms Access数据库转换为MS SQL服务器，则
在MS Access中
>数据库工具"标签
>单击"SQL Server"选项卡
遵循简单的步骤您的数据库将转换为MS SQL Serever.

或

只需将您的行复制到相应表中的SQL Server数据库中即可.

If You want to convert Ms Access Database to MS SQL server then
In MS Access
>Data base Tools tab
>Click SQL Server Tab
follow simple steps You data base will be converted into MS SQL Serever.

OR

Simply You can Copy Your Rows Into SQL server database in respective tables.