Solved

Export Access Tables as Excel

Posted on 2014-03-10
4
334 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
ID: 39919065
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
ID: 39919946
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
ID: 39920464
Ah, yes.

Thanks
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 39923148
You are welcome!

/gustav
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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…

777 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