How do I import a check box?

webmeister

Definitely certifiable
Local time
Yesterday, 20:11
Joined
Apr 6, 2006
Messages
107
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!!!!
 
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.
 

Users who are viewing this thread

Back
Top Bottom