Posted by paddy_nyr on 01/26/07 16:20

I want to use an input parameter as my filename, but I get a synatax
error message. Howerve, when I hard code the filename the proc compiles
successfully.


Thanks for any help. I'm using SQL Server 2005


LTR_90,
LTI_ELIG_pct,
LTI_REC_pct,
LOW_SALARY,
HIGH_SALARY FROM OPENDATASOURCE("Microsoft.Jet.OLEDB.4.0",
"Data Source=C:\inetpub\wwwroot\ORC_Beta_Companies\"' + @infilename +
'"Extended Properties=Excel 8.0")...[summary_data$]


Syntax message:


Msg 102, Level 15, State 1, Procedure
importExcelSpreadSheetIntoeNavigator_DataORC, Line 244
Incorrect syntax near 'Microsoft.Jet.OLEDB.4.0'.

• Next in forum: Re: Paging records on SQL 2000 : Followup question
• Prev in forum: Varchar Truncation
• Thread view: Input Paramter as part of OPENDATASOURCE

[Reply to this message]