Inserting Excel file into Database

Help
, , ,
1

Hi guys,
I am try to insert data from a excel spread sheet into a database, the column names in the excel file matches that of the database. now when I try to execute the insert statement upon reading the range, it throws an error "Insert: Missing the DataColumn ‘FirstName’ in the ‘DataTable’ for the SourceColumn ‘FirstName’ ". any ideas on how to fix this issue

2

try to log the insert statement before the database activity.

3

I do not follow

4

sorry instead of the insert statement I used the insert activity

5

@mb977 You have used Add headers while reading the Excel file right? :sweat_smile:

6

:joy: Yes I have

7

@mb977 Check if you have any Spaces in the Column Names of Excel File

8

I have already included “[ ]” in column names with spaces. am supposing that takes care of the issues that rise because of spaces

9

@mb977 Show me your Excel File :sweat_smile:

10

image

11

@mb977 Remove and Check

12

those were not initially there if I remove them, I have a different type of error

13

@mb977 What is that errror?, You dont need to put that Brackets, it will work without them

14

it sends an error of "incorrect syntax ‘.’ "

15

@mb977 Do you need those ‘.’ at the end of Column Name

16

Yes because the database am trying to insert into has columns names that includes them

17

@mb977 Then Include Brackets only for those Columns which have ‘.’ and Check

18

just tried that but the error seems to persist

19

@mb977 Same Error or Different One?

20

same syntax error