Database activity

[manojghosh89 (Manoj Ghosh)]

Can we use database activity to connect Excel file and read data from excel?

[indra]

@manojghosh89 Can you elaborate more about your question

[rajsekhar (r@j)]

yes, we can connect the excel as database connection using connect activity

[manojghosh89 (Manoj Ghosh)]

Hi Raj, may I know which dB provider to use and what about connection string. Do you have any sample file?

[rajsekhar (r@j)]

PLease find the attached file your reference.

Provider name is odbcExcel - Execute Query.xaml (8.0 KB)

[manojghosh89 (Manoj Ghosh)]

Hi Raj,
Thanks for the reply.
However I faced below problem, please help me .
: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

[rajsekhar (r@j)]

Hi Manoj,

repair ms office, then try

[Manjuts90]

@rajsekhar Hi can we do operations like insert, delete, update on excel using SQL?

[rajsekhar (r@j)]

i think only we can read the data from excel using db connection,we can’t modify

[raju (naik)]

yes we can do that by setting… read only=0…in the connection string.

[Manjuts90]

@raju can u share connection string?

[loginerror (Maciej Kuzmicz)]

I believe this sample might be useful.
Don’t forget to thank the author

Sample to use Excel as Database

Hi All, Please find the sample project. This project has all the Insert/Update/Select database queries on Excel file as Database. You have to install the Database activities from the manage package. This will be useful to update/Read a common file in case we are running multiple BOT’s without Orchestrator on multiple machine that file can be placed in the share drive. ExcelAsDB_SampleCommands.zip (20.2 KB) Hope this will be useful for all. Regards HJ