I'm not sure what you mean by "calendar form". Since you haven't got any responses, maybe nobody else does either. I can tell you how to export a table to a spreadsheet so that the first row contains the field names of the table and each subsequent row contains the data in those fields. Is that what you want?

Hoppy

yes thats what i basically want. but is there any way that the title of each column in the table will be placed not on the first row but rather on the row above it(the first row where there are A,B,C...). thanks

In Excel, the rows are designated by numbers (1, 2, 3, etc.) and the columns are designated by letters("A", "B", "C", etc.).

Anyhow, here's what you need:

Call DoCmd.TransferSpreadsheet( _
acExport, _
acSpreadsheetTypeExcel97, _
"NameOfTableOrQuery", _
"MySpreadSheet.xls")

You can find documention on TransferSpreadSheet by doing a Google search on Transferspreadsheet method". Click on the first link that comes up.

Hope this helps,

Hoppy

In Excel, you cannot change the value of A, B, C, .... which appear on top of each column.

In Excel, you cannot change the value of A, B, C, .... which appear on top of each column.

I wasn't suggesting that. I was only asking if macy2323 wanted the field names in the table to appear as the first row of the spreadsheet.

As it turns out, after having looked the documentation, the boolean parameter that determines that is ignored when exporting a table to a spreadsheet. The first row of the spreadsheet will always be the field names.

Hoppy

This article has been dead for over six months. Start a new discussion instead.