Excel ADO connection string

[riki]

Hi,

I want to connect to an Excel spreadsheet from ASP, but I don't have any idea what ADO connection string to use. Does somebody know what the Excel ADO connection string should look like?



Riki

[paul]

Riki,

Here is a sample ADO Excel connection string:

sConnectionString = "Driver={Microsoft Excel Driver (*.xls)}; DriverId=790; Dbq=D:\Your_Path_Here\Your_Excel_File_Here.xls; DefaultDir=D:\Your_Path_Here"


I hope this helps,

Paul
_________________
World Countries | Survival Skills