I have to create a report based on an excel file, I've been doing a lot of research, but I haven't found anything useful, Could someone explain me if this is possible and how can I do it.
Thanks in advance.
I have to create a report based on an excel file, I've been doing a lot of research, but I haven't found anything useful, Could someone explain me if this is possible and how can I do it.
Thanks in advance.
Hello Jeff -
This is pretty simple if your Excel workbook is laid out like a database (sheets=tables, columns=field, rows=records) and you have a Jet Universal Connector license.
More information is in the online article about using Excel as a Data Source.
Hi Harry,
The above article discusses adding an Excel data source in Jet Enterprise. Is there an article about using an Excel spreadsheet as a data source in Jet Pro? Thanks!
Hi Marian -