Exporting table from Access to Excel - Data type Yes/No

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to export a table from Access to Excel, and I have five fields
that are Yes/No data type. I updated the lookup tab to be a combo box, but
when I export the table to access, it doesn't allow me to select "Yes" or
"No". It defaults "No" in the cell, but no drop down is available.

Is there a way of doing this?
 
Are you trying to create a Yes/No field or a text files that can contain
the words "Yes" or "No"?

In either case, on the Lookup tab change the "Row Source Type" to "Value
List" and add the following to the "Row Source" "Yes;No". You cal also set
a default to either Yes or No.
 
Please ignore the typos, should have used a spell check before posting.

Message should have read:
-----------------------------------------------------------------------
Are you trying to create a Yes/No field or a text field that can contain
the words "Yes" or "No"?

In either case, on the Lookup tab change the "Row Source Type" to "Value
List" and add the following to the "Row Source" "Yes;No" ( omit the quotes )
.. You can also set a default to either Yes or No.
 
Not to mention, I went from Excel to Access instead of the way you wanted
to go.

I don't kbnow of a way to do this automatically, but manually, here's what
you can do:

Create two cells next to each other; one containing the word "Yes" the
other containing "No". They can be either verticle or horizontal. Now
select the range that you want the selection list applied to, not use the
menu and select "Data-Validation", in "Allow" select "List", then click in
the source input box. Now select the two cells containing Yes and No or
enter the address manually. Now you have a dropdown pick list.
 
Back
Top