Database insert issue

Help
, ,
1

Capture
how can i solve it?

2

Hi @arijit1213

Can you share the screenshot of Insert Activity

Thanks
Ashwin S

3

@arijit1213,

In a general Insert query no need of “from” keyword.

1 Like
4

i use insert activity and give data base table name and datatable name.

5

Whether you are using insert activity or executing the insert query in the execute non query activity???..

6

Capture2
insert activity

7

i did not use from keyword.

8

insert activity

9

The created table in sql db is, whether all columns are of type nvarchar??.
Check all the columns match’s the excel columns and sql DB column names.

10

yes.All are in nvarchar

11

Change it to varchar and check whether you are getting any error.
If again any errors comes then send your excel file and workflow.

1 Like