vb 6- exporting a database as an excel file in a tabular format(calendar form)

[macy2323]

how can i export a database from access to excel but in a tabular form(calendar form)?tnx!!!

[hopalongcassidy]

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

[macy2323]

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

[hopalongcassidy]

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

[yello]

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

[hopalongcassidy]

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

[yello]

You are right hopalongcassidy. I was just telling this to macy2323