I am really needing a solution for this if anyone can help!
I am not a programer, but am proficient with Excel, Adobe, Adobe, Livecycle Designer, etc.
I am currently using Adobe Professional XI and LiveCycle ES3. We have one computer in our office that has changed to Windows 8.1 and Microsoft Excel 2013. Previously we had Windows XP and Microsoft Excel 2007.
This is a little involved and confusing, so bear with me...
I have a livecyle form that is connected to an excel spreadsheet through an ODBC connection. With Windows XP and Microsoft Office 2007, I was able to use the xlsx version of the spreadsheet. Now, with Windows 8 and Microsoft Excel 2013, the ODBC connection process only shows the .xls version.
When Creating a new data source, in Windows XP with Microsoft Office 2007--there is an option for .xls, .xlsx, .xlsm, .xlsb
In Windows 8 with Microsoft Office 2013 the odbc does not have the option of the .xlsx
When trying to setup the excel file in the ODBC Microsoft Excel Setup window, the version options in Windows XP and Microsoft Office 2007 include Excel 12.0
However--in the Windows 8 with Microsoft Excel 2013-the Excel 12.0 is not available.
When I proceed with the data connection and then try to load the file into the livecycle designer file, I receive the following error.
GeneralError [Microsoft][ODBC Excel Driver] External Tables is not in expected format.
I have tried redoing the data connection in livecycle so that it was pointing to the file saved in the .xls format, then proceeding through the ODBC setup using the Excel 97-2000 and the .xls file format, but still get the same error.
The form runs on my computer with Excel 2007 and Windows XP, but not on my assistant's computer--she has Excel 2013 and Windows 8. However--I will be having an upgrade to my system soon, so I really need a resolution to this.
Any assistance would be greatly appreciated!