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 :
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
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
Yeah I think it’s not public
Well anyhow this topic was split into another video tutorial
@Vikas_M
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:
Maybe a side test by crosschecking with a SQL Client can help also
