Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 1997-10-16
2
Medium Priority
?
440 Views
Last Modified: 2008-03-06
Congratulations, Bruce, you figured it out! Enjoy the points...
0
Comment
Question by:loe
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 1

Accepted Solution

by:
zircon earned 200 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

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In this article, we’ll look at how to deploy ProxySQL.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

610 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