Access to Excel check box conversion

Guest

Posts: n/a

13th Apr 2009

Not sure if this is an Excel or Access question, but here goes:

Previously, when I performed a copy and paste from an Access query result to
an Excel spreadsheet, the check box values would convert from -1 to Yes, and
0 to No. For some reason, they no longer convert to anything, and are
transferred as -1 and 0.

Can anyone tell me how this happened, and how I can get back to getting the
values to convert to Yes and No??

Thanks!!

--
GD

« How do I unlink linked tables in Access 2007 to save as a backup? | Problem - Opening the vba code in a small system »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Access to Excel check box conversion	GD	Microsoft Excel Misc	5	13th Apr 2009 05:49 PM
Excel to access conversion	Janis Rough	Microsoft Access	2	7th Jul 2007 09:30 PM
Excel to Access Conversion	=?Utf-8?B?UHJvZ3JhbW1pbmcgQ2VsbHM=?=	Microsoft Access External Data	0	11th Oct 2006 04:16 PM
Excel to Access *.MDB conversion	keithnospam@gosfordchess.com	Microsoft Excel Misc	1	27th Jan 2006 12:24 PM
Access Conversion to Excel	=?Utf-8?B?U0I=?=	Microsoft Access	1	3rd Oct 2005 02:54 PM