我想使用下面的代码访问mdb文件到sql server。 [英] i want to access mdb file into sql server by using below code.

问题描述

SELECT * FROM OPENDATASOURCE（'Microsoft.Jet.OLEDB.4.0'，'Data Source = \\192.168.11.32\mdb\USERINFO.mdb'）... [USERINFO]

SELECT * FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data Source=\\192.168.11.32\mdb\USERINFO.mdb')...[USERINFO]

推荐答案

此代码工作正常.....

检查驱动程序是否已安装ODBC数据源管理员（开始>运行>类型 - ODBCAD32.EXE并按Enter键并在驱动程序选项卡下检查

This Code worked Fine.....
To check the driver is installed or not open ODBC Data Source Administrator (Start > Run > type - ODBCAD32.EXE and hit enter) and check under the Drivers tab

SET NOCOUNT ON;

Exec sp_configure 'show advanced options', 1;
RECONFIGURE;
GO

Exec sp_configure 'Ad Hoc Distributed Queries', 1;
RECONFIGURE;
GO

SELECT ID,FirstName,Surname 
FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=C:\AddressBook.mdb')...[tblContacts]

--SELECT [Field1],[Field2],[Field3],[Field4] 
--FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=Location:\Filename.mdb')
...[TableName]

Exec sp_configure 'Ad Hoc Distributed Queries', 0;
RECONFIGURE;
GO

Exec sp_configure 'show advanced options', 0
RECONFIGURE;
GO

这篇关于我想使用下面的代码访问mdb文件到sql server。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！