Solved

Export Access Tables as Excel

Posted on 2014-03-10
4
332 Views
Last Modified: 2014-03-12
When I export an Access Table as an Excel Spreadsheet, if the data has "checkbox" type data, it outputs the words "TRUE" and "FALSE" as the data.

Is there a way I can make it do 0 & 1 instead?

Thanks
0
Comment
Question by:Richard Korts
  • 2
4 Comments
 
LVL 14

Expert Comment

by:Michael Dyer
Comment Utility
If you are running an export query, you may be able to add some code to replace true with 1 and false with 0.  Otherwise, you can highlight that column in Excel and do a simple search and replace to convert True to 1 and False to 0.
0
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 500 total points
Comment Utility
Yes, don't export the table but a query:

Select Field1, Field2, Abs(CheckFieldA) As NumField1, Abs(CheckFieldB) As NumField2
Form tblYourTable

Of course, replace field and table names with those of yours.

/gustav
0
 

Author Closing Comment

by:Richard Korts
Comment Utility
Ah, yes.

Thanks
0
 
LVL 49

Expert Comment

by:Gustav Brock
Comment Utility
You are welcome!

/gustav
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

771 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now