Transfer to excel

[IanT]

Can you transfer data to excel other than in a column format. I would like to have headings on the top line and also on the left column. Is this possible!

 

[ghudson]

The TransferSpreadsheet() method will allow you to include the headers for that is one of the options. Access does not store headers on the left side. You might be able to use the Output method with a report but I have never done it so I can not give you an example [if it is possible] since Access does not store data like an Excel flat file.