Database11

Learning Initatives Automation Starter
1

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’

2

Hi , @Yogita_Gaikwad

Can you share SC of your query?

3

image
image1005×404 24.9 KB

4

@Yogita_Gaikwad ,
i doubt that order is taken as a key word (eg: ORDER BY)

5

is there any problem column name contain #

6

@Yogita_Gaikwad ,
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

7

It is possible push contain in excel to database if excel column name contain special character # for ex. ORDER#

8

Duplicate topic : Database11 - #3 by Yogita_Gaikwad

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.