Access Import destroying Excel Table/Cell format..

[rsmonkey]

Hi All, this could be very simple or hard im not really sure anyways,

I've got a very swish looking spreadsheet that imports data from an access database and it all works beautifully. However my only problem is that when it imports into Excel it squashes everything up so its rather difficult to read. So is there a way or evening a simple setting which i need to turn on that will prevent access/data import from changing any of my current cell formatting or not?

Cheers

 

[rsmonkey]

gwad damn im being a muppet this week...

bloody worked it out, cant beleive i missed it first time really!

Incase anyone is interested; its in the Data Range Properties, found on the Import Toolbar. Common sense really!