Hi- I am exploring DataBase options and need guidance to insert data into excel sheet (execute non query)
Connection tested and working when displayed no. of rows
Attaching images of error
Thanks
Greeshma
Hi- I am exploring DataBase options and need guidance to insert data into excel sheet (execute non query)
Connection tested and working when displayed no. of rows
Attaching images of error
Thanks
Greeshma
Can you show the connection string you pass ?
i think you are missing the column names there… like this:
INSERT INTO [Sheet1$] (Username, Password) VALUES ('Leaptest', 'Password')
Attaching:
Thanks for the help
Thank you for your help.
I also figured that while building connection and after selecting excel file, there is an option as Read Only if you uncheck that the execute non query will work.
Regards,
Greeshma
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.