Can we use database activity to connect Excel file and read data from excel?
yes, we can connect the excel as database connection using connect activity
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)
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
repair ms office, then try
i think only we can read the data from excel using db connection,we can’t modify