Exporting Memo Field

[tdecker81]

I need to be able to export a memo field into excel and possibly format the excel sheet to match a template file. I've done it in XML and .net 3.5 but how can I do this in Access 2010? The previous admin gave up and wrote a SSIS package to do it but that had to be triggered manually and it dumped the file to the server drive and then had to be manually moved to the file server for the requesting person to get their report.

The user needs to be able to click on the export button and actually get the file directly in the app if possible.

[June7]

I just tested exporting a table with memo field using the Export wizard in Access 2007 and it worked. What exactly is the issue you encounter?

[tdecker81]

Sorry I think i left out the most important part. I need to export more than 255 characters from a memo. It keeps truncating the exported results when pushed into Excel.

[June7]

That is what I tested, exported memo field holding more than 255 characters. Did not truncate. Also tested with Access2010. Are you use the export wizard?

[tdecker81]

This database was upgraded from Access 2000 and the default export file type was xls which does still drop anything longer than 255 characters. I changed it to xlsx file type for the export and that kept all of the data. If this was only being used internally that might work fine but I'm likely going to have to write code to open the xlsx file and save it back to the old file type to make it compatible for our customers who haven't upgraded in 5 years or installed the free compatibility software.

Thanks for your help.