SqlServer and Dbase3 conversion tools (DBF)
2016-08-23
0 0 0
no vote
Other
Earn points
Application background
The original use of SQL Server 2000 database, through DTS tools easily between the SQL server and DBF file of data import and export, now installed SQL Server2005 after and found that it provides the SQL Server import and Export Wizard in the data source is not the original rich, lack of support of DBF file.Key Technology
SQL conversion DBF file, there are generally 3 types of conversion:1, dBase file already exists:Into insertOpenrowset ('MICROSOFT.JET.OLEDB.4.0',III'dBase; DATABASE=d:', from * [*.dbf]''select)From * AAA.dbo.BBB select2, SQL table file already exists:Into AAA.dbo.BBB select from  * insert;Openrowset ('MICROSOFT.JET.OLEDB.4.0', III'dBase; DATABASE=d:', from * [*.dbf]''select)3, SQL table file does not exist, generate a new table:Select * into Openrowset ('MICROSOFT.JET.OLEDB.4.0', III'dBase; DATABASE=d:', from * [*.dbf]''select)c#
sqlserver
DBF
dbase
工具
转换
Related Source Codes
No. 186: DX0110- Source code for community propert
0
0
no vote
No. 219: DX0149- Source code for community propert
0
0
no vote
Verification code identification
0
0
no vote
CSV data analysis tool
0
0
no vote
Source code of hospital medical record information
0
0
no vote
No comment