Import Access query to Excel 2007

  • Thread starter Thread starter Office Productivity Consultant
  • Start date Start date
O

Office Productivity Consultant

Is there any way to bring in a query to a preformatted Excel spreadsheet and
have it maintain the already established column widths?
 
You may wanto to Add/Change these settings in the Query.

.PreserveFormatting = True
.AdjustColumnWidth = True
 
How do you do that in an Access 2007 query. Is that a property of the query?
 
I think I may have stated what I need incorrectly. I need to preserve the
column width in the Excel file, not the Access query. I supposed I could set
the column width in the Acess Query also.

Also, is there a way to have it not print in the headers?
 
Sorry, I was giving you the answer if you were doing a macro. I tried what
you wanted in Excel 2003 and found the solution. The last window of the
query where excel asks you where you want the data to go on the spreadsheet
is a properties selection. You can select the options you want in that box.
To eliminate the headers un-select Field Names.
 
But I am using Office 2007. I will look for something similar in 2007 but if
someone knows where to get those options in 2007, I would welcome the info.
Typically, we just do it from Excel.
 
One more thing, in Excel 2007 where you can indicate the properties, the
options to un-select field names is grayed out. Also, I need to tell it to
just keep the width of the columns. Should I be indicating the range of
columns instead of just $A$1
 
$A$1 is just where to start the table. The query wil figure out where to put
everything else. Are the headers in your data? Maybe there aren't heades and
that is why they are grayed out. If you select another table do you also get
Field Headers Grayed- Out
 
Yes, there are headers in the data. The problem is that we have a formated
spreadsheet with the columns widths already set. When we import the using the
qry file, it overrides the column with and sets it to the width of the column
headings. We don't want the headings and we don't want the column widths
changed.
I can send you screen captures of the dialog box. there is no mention in
Excel 2007 about headers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import External Data 3
Copy/Past from Word-spreadsheet format alignment disregarded 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Not all Access queries can be imported 1
Access #Error & Excel Pivot 0
Entering 24 Hour Clock without entering : 5
When opening a 2003 Spreadsheet in 2007 Column Sizes are different 2
Using MS Query with Excel and Access 2007 3

Back
Top