problems reading xls in asp ...

[RFH Reseller: RMPnet]

Hi,

does anyone have some working code to read a normal xls file using asp.

I have a couple of examples myself but they refuse to work?? I don't know if it's a compatibility issue as I'm writing xls from office 2k7.

I've breilfly attempted to read xlsx but the required driver doesn't appear to be installed - Note to Warren can you install the Microsoft.ACE.OLEDB.12.0 provider.

I've tried all the following connection strings

"DRIVER={Microsoft Excel Driver (*.xls)}; IMEX=1; HDR=NO; Excel 8.0; DBQ=" & sFilePath & "; "

"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & sFilePath & ";Extended Properties=""Excel 8.0;HDR=NO;"""

and this was the xlsx connection string I tried:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source="&sFilePath&";Extended Properties=""Excel 12.0 Xml;HDR=YES"";"

Any help would be greatly appreciated.

Regards
Keith

[Staff: Warren Ashcroft]

Where does Microsoft.ACE.OLEDB.12.0 come from?

[RFH Reseller: RMPnet]

Good question, I'd just searched for xlsx connection string and came up with http://www.connectionstrings.com/excel-2007 amongst others.

Regards
Keith

[RFH Reseller: RMPnet]

Where does Microsoft.ACE.OLEDB.12.0 come from?

Here: http://www.microsoft.com/downloads/d...displaylang=en by the looks of things. This is the 2007 Office System Driver: Data Connectivity Components

Regards
Keith

[Staff: Warren Ashcroft]

Here: http://www.microsoft.com/downloads/d...displaylang=en by the looks of things. This is the 2007 Office System Driver: Data Connectivity Components

Regards
Keith

I will get this installed for you...