By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,646 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

access export question

P: 4
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!!!

Mar 5 '10 #1
Share this Question
Share on Google+
1 Reply

Expert 5K+
P: 8,607
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.
Mar 6 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.