Database activity

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

@manojghosh89 Can you elaborate more about your question

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

1 Like

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

PLease find the attached file your reference.

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

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

Hi Manoj,

repair ms office, then try

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

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

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

@raju can u share connection string?

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