Transferspreadsheet and Too many fields defined

[grassaj]

I have an Access table with 25 fields; when I try to use the transferspreadsheet function to export it to Excel, I keep getting the "Too many fields defined" error. Is there any way to fix this problem? Thanks, Annna

 

[ETID]

Instead of exporting to, try linking from...

in excel goto data>get externa;l data>new database query...

select msaccess database* from the list and follow the wizard from there.


once the data is returned, you can right click in the data area and select prperties such as refresh on open of the xls, fill down any formulas automatically etc.


that way each time you open the xls it is refreshed with any new data in your access table or query