?
Solved

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

Posted on 1997-10-16
2
Medium Priority
?
428 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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

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 blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
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…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Suggested Courses

762 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