View Full Version : How do I import a check box?


webmeister
10-24-2006, 11:03 AM
When you're importing an Excel file into Access, how do you import a check box? When I start my import, the import doesn't let me specify anything. The Excel file in question comes across OK, but there are some check boxes on it and that data does not come across.

I'm running MS Access and Excel 2003.

Thanks in advance....looking forward to your help!!!!

pdx_man
10-24-2006, 12:26 PM
Access is only going to import the data stored in cells in Excel. If you have check boxes, then you need to see if they are linked to a cell in your workbook. Check boxes are not data, just a way of displaying the data. You may have to move the source for the check boxes to an adjacent cell and then hide the column.