Exporting an Access Table to Excel with predefined headers

[HKHESS]

Hi!!

I need to export a Access table to excel file with prefined, formatted excel headers. Presently, I use TransferSpreadSheet command in an Access macro. However, once the table is exported, I then have to reformat the Excel tab with bolding, Autoformatting, etc.

How do I avoid the manual process of reformmating the excel file for every table I export from Access to Excel??

Note: I have hundreds (100s) of such tables......Tx

 

[Norie]

Can't you do it the other way round?

That is import into Excel from Access.

If you were to do that you could record a macro to do the import and the formatting.

This could then be adapted to deal with all your tables.

 

[tails]

Re: Exporting an Access Table to Excel with predefined heade

I'd have to agree there, i was going to say record a macro to do it all for it, it will do it automatically with the press of a button (but u know that dont you). just record that macro, i dont see why you would have to do it in reverse, but it could be right.
Well thats all i got to say,