I'm new to Access 2007, but it appears to me that when exporting "with formatting and layout" that the exported file actually truncates data, if that data was not fully displayed in the source query layout (e.g. narrowed column width for overview) . Can that be true? It just seems strange to me that layout would trump data integrity - but I guess it's simplest just to leave that option unchecked.