要访问的SQL Server [英] SQL Server to Access

问题描述

使用Visual Basic 2010将大量数据库SQL Server导出到Microsoft Access的最佳方法是什么?

我正在寻找一种导出快速且数据类型的转换由我的代码控制的方法.

如果要使代码控制数据转换，最好的选择是打开SQL Server数据的数据集并对其进行一行处理一次将其插入Access.不过要提个建议-当您说有大量"数据时，根据定义，您所做的任何事情都不会很快.

What is the best method to export a lot of database SQL Server to Microsoft Access using Visual Basic 2010 ???

I am looking for a method in which the export is quick and the conversion of data types is controlled by my code.

Thanks

解决方案

If you are going to want your code to control the data conversion, your best bet is to open a dataset for the SQL Server data and process it one row at a time, inserting it into Access. A word of advice though - when you say there is a "lot" of data, by definition anything you do isn''t going to be all that quick.

这篇关于要访问的SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！