• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 445
  • Last Modified:

How can I save a Paradox crosstab as an Excel table?

Congratulations, Bruce, you figured it out! Enjoy the points...
1 Solution
The solution is a little like "which came first, the chicken or the egg?"  I'm not aware of any way to convert an actual Paradox cross-tab to an Excel spreadsheet, but you can get to the same end result by converting the information you want included in the cross-tab in table form from Paradox to Excel.  In other words, bring the "raw data" into Excel before creating the "cross-tab" instead of trying to convert the cross-tab from Paradox to Excel.

Step 1 (in Paradox):
If you need to extract the data from multiple tables in Paradox or if you don't need all of the info in a single table for the cross-tab, run a query to get the answer table containing the information you want to use in the cross-tab and then export the answer table to Excel.  Paradox 5.0 allows you to export a table to an Excel 3.0/4.0 worksheet, which will work just fine.

Step 2 (in Excel):
In Excel, a "Pivot Table" is equivalent to a "cross-tab" in Paradox.  Use the Excel Pivot Table function to create your cross-tab. Pivot Table is located in the Excel menu under Data.  In order to use the function easily and effectively, insert a new worksheet (you'll have to save your Excel file as an Excel 5.0 workbook to make this stick).  Then go to the worksheet with the source data and put the cursor anywhere within the block of source data you would like to use.  Then, the command to create the Pivot Table would basically be the menu command "Data|Pivot Table..."

From there, Excel walks you through construction of a Pivot Table (or cross-tab) using a Wizard.  To put the Pivot Table on the new work sheet you inserted earlier, when the Pivot Table wizard gets to the point where it asks you what cell you want your pivot table to start in, simply click on the tab of the new worksheet you inserted and then the cell in that worksheet in which you want the pivot table to start.

After the pivot table is finished, you may add fomatting as desired.

Best of Luck!
loeAuthor Commented:
This solution saved me a lot of trouble. It does not actually export the crosstab, but allows me to export the table and view it as a crosstab in Excel.

I am still interested in any other suggestions.

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now