[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

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

Posted on 2014-04-15
2
Medium Priority
?
2,270 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 46

Accepted Solution

by:
aikimark earned 2000 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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
I came across an unsolved Outlook issue and here is my solution.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
There may be issues when you are trying to access Outlook or send & receive emails or due to Outlook crash which leads to corrupt or damaged PST file. To eliminate the corruption from your PST file, you need to repair the corrupt Outlook PST file. U…

640 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