January 14, 2011 at 1:07 am
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