access export question

[soupy8728]

I have a query that I have exported out of Access into an Excel spread sheet. How do I set parameters on the spread sheet from Access? For example, I need to show the grid lines, center the text in the columns, and I'd like to lock the top row of cells if possible. Also, my first column contains items that are duplicated but can have more than one column associated with it. Example:

(first column) (second column) (third column)
386K 001G P185
386K 002G P196
387K 005G P155

I only want to see the first 386K, not all of them. Thanks in advance!!!

Carl

[ADezii]

After you Export the Data to an Excel Spreadsheet, you can use Automation Code to Open the Spreadsheet and properly Format it. There should be examples on Excel Automation once you do a search.