I’m playing around with ODBC data sources. When using Excel as a database, and running a query against it, how to account for the first row being a header row? Unlike the read workbook Activity, there is no checkbox to account for that here. Because the first row has headers, all columns are impo…

I finally figured it out. For anyone that comes to this, there’s a package that really helps in seeing how the data is imported. It’s called BalaReva.EasyDataTable.Activities, and it allows you to see how the data is imported, and change a column if necessary! Learn how to use it here

Excel as ODBC database, how to account for header row?

Help Activities

sudster (Sudster) October 22, 2024, 12:10am 4

@Terry_Marr

Here’s the KB article for an ODBC connection (not OLEDB), if that’s ok for you:

Topic		Replies	Views
Doubt regarding Excel has a Database Studio studio , question , activities_panel	6	571	September 4, 2023
Excel as Database - how to access without opening excel Help	13	5421	August 22, 2019
Getting error Connection String of Excel as Database Help	4	4668	October 4, 2019
Database activity Help excel , studio	11	3674	January 14, 2019
Connection string for excel Help excel , activities	15	10681	October 29, 2018

Most Active Users - Yesterday
Anil_G
jast1631
donghai
gulsheen_kaur1
More details...

Excel as ODBC database, how to account for header row?

Related topics