We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

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

loe
loe asked
on
Medium Priority
461 Views
Last Modified: 2008-03-06
Congratulations, Bruce, you figured it out! Enjoy the points...
Comment
Watch Question

Commented:
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!

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
loe

Author

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.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.