[QXL-ALL] How to get data from two or more tables into one spreadsheet.
Posted by Jack - QODBC Support on 28 July 2016 05:15 PM
How to get data from two or more tables into one spreadsheet.
In this example, We will show you How to get data from two or more tables into a single spreadsheet.
Open QXL. The first step in configuring the application is to click on the settings icon for QXL options details.
Now we change exported file configuration from the General tab Export In Single File option.
Now we will configure the table export option from the Table Settings tab.
We will choose the Selected Table option & select the table which you want to export.
In this tutorial, I select three tables (i.e., Account, Bill, and BillingRate). After selecting the table, click on close to save the configuration.
Now we will export data by clicking on the Export data icon.
QXL has started exporting tables.
The exported file got opened. All three tables are exported into one spreadsheet.