Doubt regarding Excel has a Database

Greetings everyone,

I have a query regarding a specific Property “Add Headers” which is present in reading Excel/workbook activities. When this option is unchecked, Excel introduces arbitrary column headers and treats the actual headers as regular rows.
I am interested in understanding how a similar outcome can be achieved in the context of using Excel as a database.

I’vee checked by adding HDR=No to my connection string but it didn’t work for me

Hi @Vikas_M ,

Could you provide us with the attempted connection strings, so that we can avoid suggesting you with the same again.

Also, Have you checked the below Blog :

1 Like

Hey @supermanPunch ,

Below is my Connection String

"Dsn=Excel Files;dbq=D:\Users\Downloads\ExcelHasDB\DDD.xlsx;defaultdir=D:\Users\Downloads\ExcelHasDB;driverid=1046;maxbuffersize=2048;pagetimeout=5;Header=False;"

To aid in understanding, I’ve added a screenshot here below


Did u check with this tutorials on this

Cheers @Vikas_M

Hey @Palaniyappan ,

Yes i have checked the tutorials but am not able to access the xaml file nor the spreadsheet
I get the below message when i try to login

1 Like

Yeah I think it’s not public
Well anyhow this topic was split into another video tutorial


1 Like

Thanks for your PM

in general, we would assume: Pseudo column names (A,B,C) are used instead

Its good to cross-check it within a RnD to get it validated and we encourage you to do so.

When the RnD is not working as expected then let us know all details:

  • Studio Version, relevant Package versions, set Project Compatibility
  • Excel Version
  • Data Source / Provider / ODBC Details

Maybe a side test by crosschecking with a SQL Client can help also

1 Like