Hello all...what a great resource for Access programmers. Here is my problem.....

I have set up a push button form that exports the results of a query to an excel spreadsheet. There are 2 issues:

1. I do not want column headings in the output, but they must be there in the access table. I need to export everything except the headings.

2. One particular field is weird when outputted. Example, for the last column in my spreadsheet has data like this : INVADJ 02-2003. When you look at it in access (text) field, you see it all. However, when you look at the output (excel) all you see is "2003". However, when you acually select the cell in excel, all the data appears on the formula bar and if you select edit>clear formats, all the data appears. I need to try to fix this automatically.

Thanks in advance for any help, the second wquestion is tricky, so I attached a copy of my Access generated excel file.