Import Excel ("X" or blank) field to Access Checkbox

[bbelly]

I've set myself the goal of converting an Excel "Database" to Access. Far more experience with Excel than Access.

Trying to import data that includes several fields either selected with an 'X' or left blank. Want them to show up as a checkbox, which will then become compatible with the form I have in mind.

I've tried replacing the X's and blanks as Yes/No, True False, and 0/-1. No luck there.

Thinking perhaps a macro could check or leave blank a check box based on the value in a field. So field 'RED' imported as X and blank (or any other values required) from Excel would populate field NEWRED with check boxes 'checked' for the corresponding records.



Any gurus have a suggestion?

[June7]

What method are you using to import?

What do you mean by 'no luck', what happens - error message, wrong results, nothing?

I tested import of 0/-1 with import wizard and it works. If the import creates table, the Yes/No field defaults with textbox setting, this can be changed to checkbox in table and/or on form.

[bbelly]

It only imports as a yes / no field. I cannot get the field to be a check box. Importing with the wizard.

[bbelly]

I had imported this table and by brute force created check box fields beside 'x' fields, filtered for the x, and manually filled the check box. (Space bar and plus sign worked reasonably fast) Database is at around 2500 records, with 22 fields needing check boxes. When I had finished I was shocked to find that some of the fields had dissappeared - somehow deleted the new check box field as I deleted the old true /false field. At that point I decided to try this forum to hopefully not have to repeat that insanity.

[June7]

Right, the wizard defaults to textbox control for the Yes/No field but it is still a yes/no field and can use a checkbox for this field on form. You can change the field in table to display as checkbox instead of textbox if that is really important.

Instead of manually filling a checkbox field, could probably have just changed the imported field property to display as checkbox.

22 yes/no fields makes me suspect a non-normalized data structure.