Hi

1. Microsoft Excel Odbc Driver Free Download
2. Reinstall Odbc Drivers Windows 7

Could you have a try with this one ?

Jan 19, 2017  Drivers perform specific tasks and can be classified into two categories: file-based and DBMS-based. For more information about drivers and driver architecture, see Drivers. This section contains the following topics. Using 16-Bit and 32-Bit Applications with 32-Bit Drivers. Microsoft ODBC Desktop Database Drivers. ODBC Driver for Oracle. Jul 01, 2016  This download will install a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access 2010 (.mdb and.accdb) files and Microsoft Office Excel 2010 (.xls,.xlsx, and.xlsb) files to other data sources such as Microsoft. Sep 04, 2011  Searching Google, Bing, and Microsoft Downloads doesn't list the ODBC driver setup program any further than what I've found so far. Is there a unique download link for the driver setup program or a location on an Office 2010 install disc? Microsoft ODBC Driver 11 for SQL Server is a single dynamic-link library (DLL) containing run-time support for applications using native-code APIs to connect to Microsoft SQL Server 2005, 2008, 2008 R2, SQL Server 2012, SQL Server 2014 and Windows Azure SQL Database.

• You probably need to specify the full path to the Excel Workbook file in the Dbq argument of your connection string. Or, you need to add a $ character to the end.
• Feb 21, 2017  When configuring a 32 bit ODBC datasource for an Excel file created in Microsoft Office 2010 or above you need to have the driver for.xlsx files. The 32 bit version of this driver is not installed by default with Office 2013 or above. To add this driver you need to install the Microsoft Access Database Engine 2010 Redistributable.

Sub getData()
Const adOpenStatic = 3
Const adLockOptimistic = 3
Const adCmdText = &H1

Dim conn As Object
Dim rs As Object
Dim strCon As String
Dim strSQL As String
Dim x As Long
'change the path from ThisWorkbook.FullName to your other workbook
Set conn = CreateObject('ADODB.Connection')
Set rs = CreateObject('ADODB.Recordset')
strCon = 'Provider=Microsoft.Jet.OLEDB.4.0;' & _
'Data Source=' & ThisWorkbook.FullName & ';' & _
'Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;ReadOnly=False;Format=xls' '
' Extended properties for Excel 2000/2002/2003 : Excel 8.0
' Extended properties for Excel 97 :Excel 97
' HDR header row ye sor no
' IMEX mixed data type
conn.Open strCon

'Change the name in [ ] if incorrect
strSQL = 'SELECT [TimeStamp], [HourlyTonnage] FROM [Tonnage] '
rs.Open strSQL, conn, adOpenStatic, adLockOptimistic, adCmdText

Worksheets('notcompleted').Range('A1').CurrentRegion.Clear
For x = 0 To rs.Fields.Count - 1
Worksheets('notcompleted').Range('A1').Offset(0, x) = rs.Fields(x).Name
Next x
Worksheets('notcompleted').Range('A2').CopyFromRecordset rs

rs.Close
conn.Close
Set rs = Nothing
Set conn = Nothing
End Sub

regards

Microsoft Excel Odbc Driver Free Download

JY

-->

Drivers are libraries that implement the functions in the ODBC API. Each driver is specific to a particular database management system (DBMS). In most cases, drivers expose the capabilities of the underlying DBMS; they are not required to implement capabilities not supported by the DBMS. Drivers perform specific tasks and can be classified into two categories: file-based and DBMS-based. For more information about drivers and driver architecture, see Drivers.

Reinstall Odbc Drivers Windows 7

Flight of the conchords episodes. This section contains the following topics.