Using Access 2002 on XP Pro.
Query is based on 1 table and only returns the first column which is a text field 6 characters long.
If I run the query manually and copy paste into excel I have no problems.
16938 rows, excel file size 620KB
when I put the query in a macro and select Sendobject...