Import Access query to Excel 2007
 

Is there any way to bring in a query to a preformatted Excel spreadsheet and
have it maintain the already established column widths?
--
Judy L

Import Access query to Excel 2007
 

You may wanto to Add/Change these settings in the Query.

.PreserveFormatting = True
.AdjustColumnWidth = True


"Office Productivity Consultant" wrote:

Is there any way to bring in a query to a preformatted Excel spreadsheet and
have it maintain the already established column widths?
--
Judy L

Import Access query to Excel 2007
 

How do you do that in an Access 2007 query. Is that a property of the query?
--
Judy L


"Joel" wrote:

You may wanto to Add/Change these settings in the Query.

.PreserveFormatting = True
.AdjustColumnWidth = True


"Office Productivity Consultant" wrote:

Is there any way to bring in a query to a preformatted Excel spreadsheet and
have it maintain the already established column widths?
--
Judy L

Import Access query to Excel 2007
 

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?
--
Judy L


"Joel" wrote:

You may wanto to Add/Change these settings in the Query.

.PreserveFormatting = True
.AdjustColumnWidth = True


"Office Productivity Consultant" wrote:

Is there any way to bring in a query to a preformatted Excel spreadsheet and
have it maintain the already established column widths?
--
Judy L

Import Access query to Excel 2007
 

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.

"Office Productivity Consultant" wrote:

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?
--
Judy L


"Joel" wrote:

You may wanto to Add/Change these settings in the Query.

.PreserveFormatting = True
.AdjustColumnWidth = True


"Office Productivity Consultant" wrote:

Is there any way to bring in a query to a preformatted Excel spreadsheet and
have it maintain the already established column widths?
--
Judy L

Import Access query to Excel 2007
 

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.
--
Judy L


"Joel" wrote:

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.

"Office Productivity Consultant" wrote:

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?
--
Judy L


"Joel" wrote:

You may wanto to Add/Change these settings in the Query.

.PreserveFormatting = True
.AdjustColumnWidth = True


"Office Productivity Consultant" wrote:

Is there any way to bring in a query to a preformatted Excel spreadsheet and
have it maintain the already established column widths?
--
Judy L

Import Access query to Excel 2007
 

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
--
Judy L


"Joel" wrote:

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.

"Office Productivity Consultant" wrote:

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?
--
Judy L


"Joel" wrote:

You may wanto to Add/Change these settings in the Query.

.PreserveFormatting = True
.AdjustColumnWidth = True


"Office Productivity Consultant" wrote:

Is there any way to bring in a query to a preformatted Excel spreadsheet and
have it maintain the already established column widths?
--
Judy L

Import Access query to Excel 2007
 

$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

"Office Productivity Consultant" wrote:

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
--
Judy L


"Joel" wrote:

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.

"Office Productivity Consultant" wrote:

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?
--
Judy L


"Joel" wrote:

You may wanto to Add/Change these settings in the Query.

.PreserveFormatting = True
.AdjustColumnWidth = True


"Office Productivity Consultant" wrote:

Is there any way to bring in a query to a preformatted Excel spreadsheet and
have it maintain the already established column widths?
--
Judy L

Import Access query to Excel 2007
 

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
--
Judy L


"Joel" wrote:

$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

"Office Productivity Consultant" wrote:

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
--
Judy L


"Joel" wrote:

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.

"Office Productivity Consultant" wrote:

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?
--
Judy L


"Joel" wrote:

You may wanto to Add/Change these settings in the Query.

.PreserveFormatting = True
.AdjustColumnWidth = True


"Office Productivity Consultant" wrote:

Is there any way to bring in a query to a preformatted Excel spreadsheet and
have it maintain the already established column widths?
--
Judy L