I'm very new at this, and just need to create a dsn-less connection string to an Excel spreadsheet. However, I keep getting errors!
This is my connection string script:
Code:
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_NCA_Con2_STRING
MM_NCA_Con2_STRING = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\SMU_Cheer\fpdb\NCA_IMPOR T.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";
%>
This is the error I get:
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/SMU_Cheer/Connections/NCA_Con2.asp, line 9, column 49
MM_NCA_Con2_STRING = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\SMU_Cheer\fpdb\NCA_IMPOR T.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";
------------------------------------------------^
Forgive me if this is a dumb question. I've been searching forums and blogs to get an answer, but haven't had any luck.
Many thanks!
Skye |
