如何从VB.net中的SQL Server将数据加载到mdb文件中
问题描述:
大家好,
谁能告诉我如何从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[^]"