print to excell

[Glenwood]

I have a access program in which people can click on a check box, when I export the data to excel, the check boxes show up as true or falses, I tried to creat checkboxes in the excel, but it would not export to it. and why is it you can only export to excell in an "new" file, if I set up a file in excelll with the same name as the access table and same column set up, it wont take it. or am I doing something wrong.

[SoftwareMatters]

When exporting yes/no fields to Excel i usually code them so they come out as Yes or No instead of True or False. To do this you need to amend your recordset so amend your yes/no column to something like this:

YesNo: iif([YesNoField] = -1,"Yes","No")

NB: you need to replace the [YesNoField] bit with the actual field name.

RE: Exporting to an existing Ecel template is possible. The way that I do it is to set my Exel file up with named cells and then send the information out to those cells.

Do a search for something like "export access to excel named cell" and see how you get on.