Inserting Excel file into Database

Help
, , ,
21

can you please share the workflow?

22

@mb977 There might be Errors if we try to use Special Characters in the Column Names, I had that problem as well, Hence I removed the Special Characters in both Excel and Database and it Worked :sweat_smile:

23

Hi
INSERT activity will work buddy
Kindly cross check once the column names in both excel and the database are same
And also the order of columns

Cheers @mb977

24

:grinning:its frustrating man, I will try and see if it makes any difference. thanks for your time tho

25

its all the same

26

@mb977
are you adding the data to existing column?
and is there any other columns apart from as shown in screenshot

27

Am adding the data to existing columns and no there is no other columns

28

Can you share the Insert Query statement used in code?

29

I have the same problem

30

HIi HAVE IN PROBLEME IN UiPath STUDIO System.Data.Odbc.OdbcException: ERROR [42000] [MySQL][ODBC 8.3(w) Driver][mysqld-8.3.0]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘DEFAULT VALUES’ at line 1 at