Importing data from a Microsoft Excel file is similar to the process used to import data from a CSV file and entails creating a Standard DataShare Connection using the Microsoft Jet 4.0 OLE DB Provider.
...
| Tip |
|---|
If you wish to import an XLSX file into Data Share the easiest way to do this is to either export to the old XLS format and follow the steps below or to a CSV file and follow the steps on importing CSV Files. You should also be able to import in the XLSX format as long as you use the correct connection parameters (although you might need the relevant 32 bit driver). |
Working with the Datasource in Data Share
...