i have excel which contain column name ORDER# and i want to push in database for that in multiple assign i have create variable vOrder and in insert query pass Order which is column name create in database and vOrder also pass but it gives an error
error: Incorrect syntax near the keyword ‘Order’
Hi , @Yogita_Gaikwad
Can you share SC of your query?
i doubt that order is taken as a key word (eg: ORDER BY)
is there any problem column name contain #
Give the full column name correctly and give a try,
If that is still throwing an error, then try removing [POC].[dbo] because might u have provided the database name and all in the connection string , so it can identify the extact table without it
It is possible push contain in excel to database if excel column name contain special character # for ex. ORDER#
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.