Using Excel Files as Data Source

//Using Excel Files as Data Source

Using Excel Files as Data Source

Excel files actually can be used as a merge source. However, there are a
few things to know. (Worth knowing, it is a common requirement)

You can use them as an ODBC (database) source. You need to:

1: Install the uSOft 64 bit drivers (finally available)
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13255
Go to control panel administrative tools/ODBC Data Sources (64-bit)
and add in the excel driver
Driver is ‘Excel 12.0’ and give it a name (eg: Excel :))

2: When setting the merge source in the workflow manager
Select ‘Database’ and enter the name of the driver in the DSN box.
Then comes the undocumented
uSoft trick:
You need to enter the table name. One might expect that would
be the name of the excel
‘sheet’ name. CLOSE BUT NO CIGAR! If the name is ‘my sheet 1’
you need to enter:

[my sheet 1$]

That is, excel tables are named as the sheet name followed by a
‘$’ and then enclosed
in square brackets!

By |2017-10-31T13:47:14-07:00October 30th, 2017|Setup|0 Comments

Leave A Comment