ormatting Imported data from Access 03

Z

zach

Hi all,

I have data from a access DB that i am exporting into a table in excel.
This table keeps track of samples and what testing has been done to
them in a lab. When the data is refreshed the formatting for my table
[e.g. bolds, fonts, center, etc] gets wiped out, except for the first
line and the column headers. What is going on here, is access
overriding my formatting, and if so is there a way to decide how excel
will handle the data it recieves from access and format it on the fly?
Thanks in advance,

-Zach
 
C

CLR

I import all my data using a macro through MSQuery. This macro, besides
updating my data can also perform any formatting that I wish. This technique
might serve you as well.......

Vaya con Dios,
Chuck, CABGx3
 
H

Huff

Zach

If you create a refresh query in Excel to pull the data from Access
there's a tick box option to preserve cell formatting within the Data
Range Properties sheet of the query.
If you're doing a 'Transfer Spreadsheet' from Access I don't think
there is a way to preserve the formatting other than by creating an
Excel macro as the previous post suggests.

HTH
 
Top