Solved

Export Access Tables as Excel

Posted on 2014-03-10
4
333 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to put password on a button in Access 2013 4 40
ms/access hyperlink/ftp 7 34
Two list boxes - best structure 3 31
MS-Access 2002 error (Win XP on Win7Pro) 19 35
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
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…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

919 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

23 Experts available now in Live!

Get 1:1 Help Now