Solved

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

Posted on 1997-10-16
2
389 Views
Last Modified: 2008-03-06
Congratulations, Bruce, you figured it out! Enjoy the points...
0
Comment
Question by:loe
2 Comments
 
LVL 1

Accepted Solution

by:
zircon earned 50 total points
ID: 1025353
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!
0
 

Author Comment

by:loe
ID: 1025354
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.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question