Exporting an Access Table to Excel with predefined headers

HKHESS

New Member
Joined
Feb 2, 2005
Messages
1
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
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,216
Office Version
  1. 365
Platform
  1. Windows
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

Board Regular
Joined
Jan 30, 2005
Messages
130
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,
 

Watch MrExcel Video

Forum statistics

Threads
1,122,371
Messages
5,595,777
Members
414,020
Latest member
Meghdad

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top