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
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