如何从VB.net中的SQL Server将数据加载到mdb文件中 [英] how to load data into an mdb file from SQL server in VB.net

问题描述

大家好，

谁能告诉我如何从VB.net中的SQL Server将数据加载到mdb文件中?
请提供一些示例代码.

提前谢谢.

问候，
Srinivas.

Hi Guys,

Can any one tell me how to load data into an mdb file from SQL server in VB.net?
Please provide me some sample code.

Thanks in advance.

Regards,
Srinivas.

推荐答案

您可以按照此处 [ ^ ]或 http://social.msdn.microsoft.com/Forums/zh/adodotnetdataproviders/thread/4f576c4a-5e07-450c-bc15-0c0732707673 [ http://www.youtube.com/watch?v=yexpN4HYilc [ http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50564 [ ^ ]
用于访问的批量记录插入 [ OPENROWSET [ http://www.ehow.com/how_6116289_import-using-sql-stored-procedures.html [^ ]
http://www.ehow.com/how_5850212_export-data-sql-2005-access.html [^ ]

You can do it the same way as is descibed here[^] or here[^] or here[^] ;)

More at:
http://social.msdn.microsoft.com/Forums/en/adodotnetdataproviders/thread/4f576c4a-5e07-450c-bc15-0c0732707673[^]
http://www.youtube.com/watch?v=yexpN4HYilc[^]
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50564[^]
Bulk Record Insert for Access[^]
OPENROWSET[^]
http://www.ehow.com/how_6116289_import-using-sql-stored-procedures.html[^]
http://www.ehow.com/how_5850212_export-data-sql-2005-access.html[^]

您已经被告知如何处理其他问题.如果您希望有人为您编写代码，那么您来错了地方.

如果您只是通过Google搜索" ^ ]"

You''ve already been told how in your other question. If you want someone to write your code for you, you''ve come to the wrong place.

There''s a ton of links on doing this if you just Google for "VB.NET SQL SSIS[^]"

这篇关于如何从VB.net中的SQL Server将数据加载到mdb文件中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！