Read an Excel worksheet row by row

The project attached below uses the Database/ERP task to open a connection to an Excel workbook called people.xlsx and read all the rows from the worksheet called Sheet1 one by one.  Note that you must have the 32-bit Microsoft Office Access Database Engine OLE DB provider on your machine in order for this to work.  This is included with the 32-bit version of Microsoft Office 2007 or later.  If you don’t have the 32-bit version of Microsoft Office installed, then you can download the 32-bit version of the Microsoft Access Database Engine.  This project was developed using the Microsoft Access Database Engine 2010 available from https://www.microsoft.com/en-us/dow...x?id=13255.

Larry