adrianzazugmail.com Posted January 3, 2018 Share Posted January 3, 2018 Is it possible to use an Excel sheet as a database?Hello, I use Ireport with a SQL database and others, I use the query to make reports and use sentences for filter queries. I want to do the same with an Excel sheet but I do not get information on the subject, only to export and import.I want to use an Excel sheet as a database, the idea is that users capture the information in the Excel sheet and make a report with this information as it is done with other databases. Thank you Link to comment Share on other sites More sharing options...
vchiem Posted January 12, 2018 Share Posted January 12, 2018 There is the Microsoft Excel data adapter (xls, xlsx) which allows you to use excel document as data source. If you are not seeing this as an option when creating data adapter then it is due to the version of Studio / iReport . Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now