Update Excel file using OLEDB

#1
Hi,

I have to update an excel file with values that I have in a Collection. Basically in the Collection they are ordered from highest to lowest.
Surely using the VBO MS Excel is possible, but I must specifically use OLEDB.
I need to update the excel with the values found in the collection.
Note1: I already have the Connection done but I need the appropriate SQL commands to put in the Execute.
I attach excel file and capture of the Collection

Note2: McDonald's apostrophe (') may cause an error in the execution of the SQL statement

Thank you
 

Attachments

#2
Hi,

I want to perform operations like filter data, get data using Data-OLEDB VBO. For Using this object I had gone through document of OLEDB. When I am setting connection as per the document I am getting error as "Could not Execute code stage because exception thrown by code stage :Format of the initializing string does not conform to a specification starting at index 152"

I am passing connection string as "

Provider=Microsoft.ACE.OLEDB.12.0;Data Source="D:\Blue Prism\Business Planning and operations\Pipeline Tracker Base Creation\TSU-Pipeline-Tracker.xlsx";Extended Properties="Excel 12.0 Xml;HDR=YES;

"
Data source is the file path of my excel.
I had installed Microsoft Access DataBase Engine also as per the guide.


Thanks and Regards,
Varsha Kanthikar
 
#3
Hi,

I want to perform operations like filter data, get data using Data-OLEDB VBO. For Using this object I had gone through document of OLEDB. When I am setting connection as per the document I am getting error as "Could not Execute code stage because exception thrown by code stage :Format of the initializing string does not conform to a specification starting at index 152"

I am passing connection string as "

Provider=Microsoft.ACE.OLEDB.12.0;Data Source="D:\Blue Prism\Business Planning and operations\Pipeline Tracker Base Creation\TSU-Pipeline-Tracker.xlsx";Extended Properties="Excel 12.0 Xml;HDR=YES;

"
Data source is the file path of my excel.
I had installed Microsoft Access DataBase Engine also as per the guide.


Thanks and Regards,
Varsha Kanthikar
Try this
Provider=Microsoft.ACE.OLEDB.12.0;Data Source="D:\Blue Prism\Business Planning and operations\Pipeline Tracker Base Creation\TSU-Pipeline-Tracker.xlsx";Extended Properties="Excel 12.0 Xml;HDR=YES"; (" is missing between YES and ;)
 
Top