import Excel file in SQL 2005 Table as a variable filename

  • I am struggling with this and could not figure out. I need to import an excelfile as an variable.

    The code is

    ----------

    Create Proc bulkinsertfromexcel

    as

    Begin

    Declare @sessionID nvarchar(MAX)

    Declare @docpath nvarchar(max)

    Declare @jobcreator nvarchar(max)

    Declare @SQL nvarchar(MAX)

    DECLARE @filename varchar(100)

    Set @docpath = 'E:\Workflow\SPP\Attachments\TR\ExcelUpload\''+@filename'

    Set @SQL = 'INSERT INTO [Tactical.Claim_LineItems_BULK_Audi] ([JObCreator], [ModelCode],

    [ChassisNo], [CommissionNo], [AGSupport],[AVMESupport], [Brand], [Remark])

    SELECT A.[JObCreator], A.[ModelCode], A.[ChassisNumber], A.[CommisionNumber],

    A.[AG], A.[AVME], A.[Brand], A.[Remarks]

    FROM OPENROWSET (''Microsoft.ACE.OLEDB.12.0'', ''Excel 12.0;;Database=''+@docpath+'', ''select * from [Sheet1$]'') AS A';

    PRINT @SQL

    EXEC(@SQL)

    End

    ---------------

    The error is

    -----------

    Msg 102, Level 15, State 1, Procedure bulkinsertfromexcel, Line 23

    Incorrect syntax near ','.

    ------------

    Any help to figure out this issue and run the sp successfully is highly appreciated

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply