将数据从数据表移动到MsAccess表 [英] Moving data from a DataTable to An MsAccess Table

问题描述

你好，
一个具有由SQL Server查询使用SQL .net对象(命令，连接，适配器等)填充的数据表.

我需要将这些数据表移动到Ms Access表中.

我已经使用ADOX在目标mdb中创建数据库和表，但是我坚持将数据表中的数据移动到新创建的ms access数据库表中.
预先感谢您的想法和建议
Ali

Hello,
A have a data table populated by a SQL server query using a SQL .net objects (command, connection, adapter etc).

What I need is to move this data tables into an Ms Access Table.

I have used the ADOX to create a database and table in the target mdb but I stuck on the part of moving the data in the data table into the newly created ms access database table.

Thanks in advance for you ideas and suggestions
Ali

推荐答案

数据是否驻留在SQL Server表中?如果是这样，请进入Access并将表手动导入到Access db中，而忘记整个编码位.我之所以这样说，是因为如果可以的话，手动操作会更容易.

Does the data reside in a SQL Server table? If so then go into Access and import the tables into your Access db manually and forget the whole coding bit. I say this because it is easier to do this manually if you can.

这篇关于将数据从数据表移动到MsAccess表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！