Posted by Steve on 01/26/07 18:40

Try puting the entire statement into a string variable and then
executing the string.

On Jan 26, 8:20 am, "paddy_nyr" <mpp...@yahoo.com> wrote:
> 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: sql 2005 - optimization - cannot use index
• Prev in forum: Re: The age old argument of Temp table vs Table variable
• Thread view: Re: Input Paramter as part of OPENDATASOURCE

[Reply to this message]