Solved

Importing TRUE/FALSE field from excel to Access Table - no checkboxes seen

Posted on 2014-04-15
2
1,971 Views
Last Modified: 2014-04-15
I have a raw excel file that has TRUE or FALSE for a [columnSpec]. Now I want to import that data in a similar table structure in access with the same number of columns and column data types. The [columnSpec] column in the access is a Yes/No field. Now when I load it, it gets loaded to the table with the values TRUE or FALSE but I don’t see any checkboxes that are checked or unchecked. How can I load the TRUE/FALSE filed in raw excel into a access table’s YES/NO field type, so that I am able to see the checkboxes for that field checked or unchecked?
0
Comment
Question by:Rayne
2 Comments
 
LVL 45

Accepted Solution

by:
aikimark earned 500 total points
ID: 40002563
You have to change the lookup property of the field in the table to checkbox.
0
 

Author Comment

by:Rayne
ID: 40002621
thank you Aikimark :)
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
My experience with Windows 10 over a one year period and suggestions for smooth operation
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…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

830 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