What ODBC Driver for XL 2003?

  • Thread starter Thread starter Gorge Bush
  • Start date Start date
G

Gorge Bush

Hi there,
can anyone tell me if there are updated ODBC drivers for XL
2003? The reason that I ask is because when I set up a data source that
points to an .XLS file, you can only select up to Excel 2000. When I view
the spreadsheet in MS Query, some of the cells that contain data in the
spreadsheet are blank.
I don't know what installed MDAC and the drivers. Either SQL Server 2000,
Visual Studio 6, VS .Net 2003 or MS Office 2003. The driver version is
4.00.6019.00.
 
...

Unfortunate name.
can anyone tell me if there are updated ODBC drivers for XL
2003? The reason that I ask is because when I set up a data source that
points to an .XLS file, you can only select up to Excel 2000.
Click to expand...

I'm more familiar with the Microsoft OLE DB Provider for Jet. For
Excel2000 workbooks I specify 'Excel 8.0' (Excel97 format) because
this is the latest version recognized. Presumably the same applies to
ODBC drivers.
When I view
the spreadsheet in MS Query, some of the cells that contain data in the
spreadsheet are blank.
Click to expand...

AFAIK, the Excel file format (whatever that is) hasn't changed since
Excel97. Rather than an You are probably getting blank rows due to a
'mixed data types' situation. More details may be found on Dick
Kusleika's site:

http://www.dicks-blog.com/excel/2004/06/external_data_m.html

Jamie.

--
 
Back
Top