View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
connie connie is offline
external usenet poster
 
Posts: 46
Default Formatting with imported data

Hi all,
I have imported data into Excel 07 from Access 02/03. There are 2 things I
would like to change.

1. The formatting that imports with the data changes the colour of the Excel
cells.

2. Headings are imported automatically with the data, and I would like the
option of changing this. These headings are dropdowns that allow sorting
choices.

Basically I need the data to import with no headings, and no formatting at
all.

Any help appreciated,
Connie