Excel as database: Query working, but excel not getting updated

ndhiran · November 8, 2019, 5:57pm

Hi,
I am using excel as database. My update query gives me correct number of rows updated. But when i check in excel, rows are not getting updated.
Can someone please help me ?

My connection string:
“Dsn=Excel Files;dbq=”+excelFileName+“;defaultdir=D:;driverid=1046;maxbuffersize=2048;pagetimeout=5;IMEX=-1”

sarathi125 · November 9, 2019, 12:55am

@ndhiran,
Are you using any excel related activities for this operation to write the values in the excel?

pattyricarte · November 9, 2019, 1:02am

Can i see you workflow seems interesting.

@ndhiran

cheers

Happy learning

Topic		Replies	Views
Update Query returns null value if we update after performing excel activities Activities excel , studio , question	3	1460	January 11, 2021
Execute non query not working when excel is closed - excel as database Activities excel , database , activities , question , uipath-database-activities	2	1140	December 21, 2021
Update query not working in Excel when Excel is connected as a Database Help datatable , excel , activities , error	0	1603	November 28, 2019
Very often update query is not working when Excel is connected using connection string (oledb) Activities excel , database , activities , question	14	3838	October 29, 2024
Need to update the excel values in DB Activities database , activities , question	6	667	September 5, 2023

Excel as database: Query working, but excel not getting updated

Related topics