如何在.NET中将SDF转换为MDB [英] How to convert SDF to MDB in .NET

问题描述

嗨！

我需要将数据从Compact SQL文件(sdf)读取到Access .mdb.我设置了对System.Data.SqlServerCe的引用.这是我正在使用的代码，但我得到的是:在连接字符串或IN子句中未指定数据库."

子Main()
昏暗的AccessConn作为新的System.Data.OleDb.OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = MyResultFile.mdb")

AccessConn.Open()

昏暗的AccessCommand作为新的System.Data.OleDb.OleDbCommand(String.Format("SELECT * INTO [MyTable] FROM [MyTable] IN''''{0}"，"[Provider = Microsoft.SQLSERVER.CE.OLEDB.3.5 ; Data Source = MySourceFile.sdf;最大缓冲区大小= 1024;最大数据库大小= 1000; Persist Security Info = False;];)，AccessConn)

AccessCommand.ExecuteNonQuery()
AccessConn.Close()

结束子

当我用数据库"替换数据源"时，我得到的是找不到可安装的ISAM."

谁能帮忙吗?

问候.

Hi!

I need to read the data from Compact SQL file (sdf) to Access .mdb. I set reference to System.Data.SqlServerCe. Here is the code that I''m using, but I''m getting: "No database specified in connection string or IN clause."

Sub Main()
Dim AccessConn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MyResultFile.mdb")

AccessConn.Open()

Dim AccessCommand As New System.Data.OleDb.OleDbCommand(String.Format("SELECT * INTO [MyTable] FROM [MyTable] IN '''' {0}", "[Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=MySourceFile.sdf;Max Buffer Size=1024;Max Database Size = 1000;Persist Security Info=False;];"), AccessConn)

AccessCommand.ExecuteNonQuery()
AccessConn.Close()

End Sub

When I replace "Data Source" with "DataBase" I''m getting "Could not find installable ISAM."

Could anyone please help?

Regards.

推荐答案

，您可以使用第三方商业应用程序http://www.dbnetcopy.com/，该应用程序将在SQL Server Compact和大多数其他主要数据库之间复制数据.供应商.对于非许可版本，每张表限制为1000条记录.

希望对您有帮助

you can use a third party commercial application http://www.dbnetcopy.com/ that will copy data between SQL Server Compact and most other major database vendors. Limited to 1000 records per table for the non-licensed version.

Hope this will help you

这篇关于如何在.NET中将SDF转换为MDB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！