Excel Data

[WestView]

Hello All,

I'm using CR 10 and I've been given an Excel spreadsheet to generate a report from. Normally, no problem. However, with this spreadsheet the author inserted multiple (12) 'Check Boxes' in one column and grouped them together. One, all, some or none of these check boxes may be toggled. I need the toggled (checked) values.

I've tried to create the report by connecting directly (ADO) to the spreadsheet and by linking/importing the spreadsheet into an Access database and connecting to that. Neither method converts the data from the cells of the checkbox column.

Does anyone have any suggestions on how I could accomplish this? Or, in fact, is this even possible?

Thanks for any/all suggestions!

- Tom

 

[VBrit]

I would say it's not possible, as each checkbox will be an individual ActiveX control, effectively embedded within your spreadsheet. You would be better off using true / false or 1/0 values where these checkboxes reside if you wish to use the values in your report.

VBrit

 

[WestView]

VBrit,

Thank you for your reply. I thought as much but held out foolish hope there might be a way.

Thanks again!

- Tom