Use the REST Connector to parse nested Value Arrays Reopen the map an you should no longer get the error. Now hit Validate, and then hit Preview and save the map. If the “Sheet” drop down does not fill in, click on the drop down and select the Sheet that contains the data. Browse out to the location of the Excel file, select the file, and then hit Open. Go to the data source section of the map, and click on the “Browse” button at the far right on the Excel pathname. Click OK on the error message, which will give you a warning that you need to enter a valid data source before continuing, click OK on that message as well. This means your pathname to the Excel file is incorrect. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.When opening a SmartConnect map that uses an Excel datasource, receiving an error that says this:ĮRROR General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x514 Thread 0x1d4c DBC 0xc1c85f4 Excel’.ĮRROR Invalid connection string attribute FirstRowHasNamesĪ screenshot of the error looks like this

The entire risk arising out of the use or performance of the sample code is borne by the user. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The sample code is provided on an 'AS IS' basis. Progress Software Corporation makes no explicit or implied claims to the validity of this information.Īny sample code provided on this site is not supported under any Progress support program or service. However, the information provided is for your information only. Progress Software Corporation makes all reasonable efforts to verify this information. The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”).

Open odbc excel