Probably a trivial answer. My Access 97 doesn't have the option to export to xls format! I made sure that everything from the Office CD is installed but still don't have the option. Right now I do it the long way, I export into csv which then I get into Excel. But I'm pretty sure that any
Access table/query should be exportable directly to xls format. Any idea anybody? Thanks
All good ideas. I didn't say I can't export it, there is surely more ways to do it. ODBC, copy/paste, .csv format, etc. I just wonder why I don't have the option to do save/open(!) xls. I can even import an existing xls spreadsheet before I convert it to csv file.
tscyps, not a bad idea if I want to export only from one app, however, I'm having the problem accross the board with any Access DB. Even worse, I've noticed that some of my users lost the feature as well... Thanks anyway!
Create a macro in every database. Make it for each OUTPUTTED report/table and you shoudlnt have a problem. the OUTPUT TO is available in every Access version and to all users. The only reason it shouldnt work is if someone didnt have excel.