Trying to Export Report to Excel 2003

  • Thread starter Thread starter scott04
  • Start date Start date
S

scott04

Hi everyone,

I am using access 2003 and am trying to export a report that comes from a
query to excel however some of the text is cut off. I have read others
problems but couldnt find the shoe that fit. Can someone help? Can i have
some sort of marco that runs my query and then dumps it into excel fully? If
so please explain. Thanks for your help!

Scott
 
Gina,

I first tried just pulling my report. Then clicked export and tried to dump
data in excel 1997-2003 and the other version of excel. It cut off probabbly
after 255 characters when it transfered it to excel.

I have tired the transferspreadsheet method but that did not seem to work
for me. I was thinking there had to be an easier way then what i was doing.
The only time it fully copied everything is when i transfered the query to
XML. When i did that it kept my entire memo field. I do not want to have in
in XML since my end user really just needs it in excel.
 
SELECT [Ask PMQS].Status, [Ask PMQS].Date_Received, [Ask PMQS].Topic, [Ask
PMQS].[Question Category], [Ask PMQS].Question, [Ask PMQS].Answer, [Ask
PMQS].[CRS Training/Help Site Resource], [Ask PMQS].Notes
FROM [Ask PMQS]
WHERE ((([Ask PMQS].Status)=3) AND (([Ask PMQS].Date_Received) Is Not Null
And ([Ask PMQS].Date_Received) Between [Please enter start date] And [Please
enter end date]));
 
Is it the Notes field that is the Memo field?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

scott04 said:
SELECT [Ask PMQS].Status, [Ask PMQS].Date_Received, [Ask PMQS].Topic, [Ask
PMQS].[Question Category], [Ask PMQS].Question, [Ask PMQS].Answer, [Ask
PMQS].[CRS Training/Help Site Resource], [Ask PMQS].Notes
FROM [Ask PMQS]
WHERE ((([Ask PMQS].Status)=3) AND (([Ask PMQS].Date_Received) Is Not Null
And ([Ask PMQS].Date_Received) Between [Please enter start date] And
[Please
enter end date]));

Gina Whipp said:
Scotty,

Copy/Paste the SQL of the query here...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm




.
Click to expand...
Click to expand...
 
Another question... is Ask PMQS a table or query? If it is a query what is
the SQL of that query?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

scott04 said:
SELECT [Ask PMQS].Status, [Ask PMQS].Date_Received, [Ask PMQS].Topic, [Ask
PMQS].[Question Category], [Ask PMQS].Question, [Ask PMQS].Answer, [Ask
PMQS].[CRS Training/Help Site Resource], [Ask PMQS].Notes
FROM [Ask PMQS]
WHERE ((([Ask PMQS].Status)=3) AND (([Ask PMQS].Date_Received) Is Not Null
And ([Ask PMQS].Date_Received) Between [Please enter start date] And
[Please
enter end date]));

Gina Whipp said:
Scotty,

Copy/Paste the SQL of the query here...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm




.
Click to expand...
Click to expand...
 
Actually it is the Question field the dept wanted a memo field.

Gina Whipp said:
Is it the Notes field that is the Memo field?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

scott04 said:
SELECT [Ask PMQS].Status, [Ask PMQS].Date_Received, [Ask PMQS].Topic, [Ask
PMQS].[Question Category], [Ask PMQS].Question, [Ask PMQS].Answer, [Ask
PMQS].[CRS Training/Help Site Resource], [Ask PMQS].Notes
FROM [Ask PMQS]
WHERE ((([Ask PMQS].Status)=3) AND (([Ask PMQS].Date_Received) Is Not Null
And ([Ask PMQS].Date_Received) Between [Please enter start date] And
[Please
enter end date]));

Gina Whipp said:
Scotty,

Copy/Paste the SQL of the query here...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I am not sure what you mean by distinct but there is not any grouping in
the
query.

:

Scott,

Are you using DISTINCT in your query?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina,

I first tried just pulling my report. Then clicked export and tried
to
dump
data in excel 1997-2003 and the other version of excel. It cut off
probabbly
after 255 characters when it transfered it to excel.

I have tired the transferspreadsheet method but that did not seem to
work
for me. I was thinking there had to be an easier way then what i
was
doing.
The only time it fully copied everything is when i transfered the
query
to
XML. When i did that it kept my entire memo field. I do not want
to
have
in
in XML since my end user really just needs it in excel.



:

Scott,

You say some of the text is cut off... Are you trying to export a
Memo
field? How much is some? How are you exporting...
TransferSpreadsheet?
Do
you have an Export Specification?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi everyone,

I am using access 2003 and am trying to export a report that
comes
from
a
query to excel however some of the text is cut off. I have read
others
problems but couldnt find the shoe that fit. Can someone help?
Can
i
have
some sort of marco that runs my query and then dumps it into
excel
fully?
If
so please explain. Thanks for your help!

Scott


.



.



.
Click to expand...
Click to expand...


.
Click to expand...
 
Scott,

Okay but is [[Ask PMQS] a query? And what version of Excel do you have, you
said Access 2003 but not spedify Excel version? I have tried this using
TransferSpreadsheet and File|Export and have been successful both times,
whether I open in Excel 2003 or Excel 2007.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

scott04 said:
Actually it is the Question field the dept wanted a memo field.

Gina Whipp said:
Is it the Notes field that is the Memo field?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

scott04 said:
SELECT [Ask PMQS].Status, [Ask PMQS].Date_Received, [Ask PMQS].Topic,
[Ask
PMQS].[Question Category], [Ask PMQS].Question, [Ask PMQS].Answer, [Ask
PMQS].[CRS Training/Help Site Resource], [Ask PMQS].Notes
FROM [Ask PMQS]
WHERE ((([Ask PMQS].Status)=3) AND (([Ask PMQS].Date_Received) Is Not
Null
And ([Ask PMQS].Date_Received) Between [Please enter start date] And
[Please
enter end date]));

:

Scotty,

Copy/Paste the SQL of the query here...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I am not sure what you mean by distinct but there is not any grouping
in
the
query.

:

Scott,

Are you using DISTINCT in your query?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina,

I first tried just pulling my report. Then clicked export and
tried
to
dump
data in excel 1997-2003 and the other version of excel. It cut
off
probabbly
after 255 characters when it transfered it to excel.

I have tired the transferspreadsheet method but that did not seem
to
work
for me. I was thinking there had to be an easier way then what i
was
doing.
The only time it fully copied everything is when i transfered the
query
to
XML. When i did that it kept my entire memo field. I do not
want
to
have
in
in XML since my end user really just needs it in excel.



:

Scott,

You say some of the text is cut off... Are you trying to export
a
Memo
field? How much is some? How are you exporting...
TransferSpreadsheet?
Do
you have an Export Specification?

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi everyone,

I am using access 2003 and am trying to export a report that
comes
from
a
query to excel however some of the text is cut off. I have
read
others
problems but couldnt find the shoe that fit. Can someone
help?
Can
i
have
some sort of marco that runs my query and then dumps it into
excel
fully?
If
so please explain. Thanks for your help!

Scott


.



.



.
Click to expand...


.
Click to expand...
Click to expand...
 
Gina,

I am using excel 2003 as well...if i run the query all along i get all of
the data from the memo field. I do not get the data when i transfer or
export as it cuts at 255 characters. Using the mid function in the query
from (1, 255) then (256, 500) works but does not look nice since sometimes
words are cut up.

Gina Whipp said:
Scott,

Okay but is [[Ask PMQS] a query? And what version of Excel do you have, you
said Access 2003 but not spedify Excel version? I have tried this using
TransferSpreadsheet and File|Export and have been successful both times,
whether I open in Excel 2003 or Excel 2007.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

scott04 said:
Actually it is the Question field the dept wanted a memo field.

Gina Whipp said:
Is it the Notes field that is the Memo field?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

SELECT [Ask PMQS].Status, [Ask PMQS].Date_Received, [Ask PMQS].Topic,
[Ask
PMQS].[Question Category], [Ask PMQS].Question, [Ask PMQS].Answer, [Ask
PMQS].[CRS Training/Help Site Resource], [Ask PMQS].Notes
FROM [Ask PMQS]
WHERE ((([Ask PMQS].Status)=3) AND (([Ask PMQS].Date_Received) Is Not
Null
And ([Ask PMQS].Date_Received) Between [Please enter start date] And
[Please
enter end date]));

:

Scotty,

Copy/Paste the SQL of the query here...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I am not sure what you mean by distinct but there is not any grouping
in
the
query.

:

Scott,

Are you using DISTINCT in your query?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina,

I first tried just pulling my report. Then clicked export and
tried
to
dump
data in excel 1997-2003 and the other version of excel. It cut
off
probabbly
after 255 characters when it transfered it to excel.

I have tired the transferspreadsheet method but that did not seem
to
work
for me. I was thinking there had to be an easier way then what i
was
doing.
The only time it fully copied everything is when i transfered the
query
to
XML. When i did that it kept my entire memo field. I do not
want
to
have
in
in XML since my end user really just needs it in excel.



:

Scott,

You say some of the text is cut off... Are you trying to export
a
Memo
field? How much is some? How are you exporting...
TransferSpreadsheet?
Do
you have an Export Specification?

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi everyone,

I am using access 2003 and am trying to export a report that
comes
from
a
query to excel however some of the text is cut off. I have
read
others
problems but couldnt find the shoe that fit. Can someone
help?
Can
i
have
some sort of marco that runs my query and then dumps it into
excel
fully?
If
so please explain. Thanks for your help!

Scott


.



.



.



.
Click to expand...
Click to expand...


.
Click to expand...
 
Scott,

Okay, I am getting stumped becase as I said, I ran some tests and cannot
duplicate... Let's try this, what happens if you use TransferSpreadsheet on
the table? Also, copy/paste the TransferSpreadsheet line you are using
here.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

scott04 said:
Gina,

I am using excel 2003 as well...if i run the query all along i get all of
the data from the memo field. I do not get the data when i transfer or
export as it cuts at 255 characters. Using the mid function in the query
from (1, 255) then (256, 500) works but does not look nice since sometimes
words are cut up.

Gina Whipp said:
Scott,

Okay but is [[Ask PMQS] a query? And what version of Excel do you have,
you
said Access 2003 but not spedify Excel version? I have tried this using
TransferSpreadsheet and File|Export and have been successful both times,
whether I open in Excel 2003 or Excel 2007.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

scott04 said:
Actually it is the Question field the dept wanted a memo field.

:

Is it the Notes field that is the Memo field?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

SELECT [Ask PMQS].Status, [Ask PMQS].Date_Received, [Ask
PMQS].Topic,
[Ask
PMQS].[Question Category], [Ask PMQS].Question, [Ask PMQS].Answer,
[Ask
PMQS].[CRS Training/Help Site Resource], [Ask PMQS].Notes
FROM [Ask PMQS]
WHERE ((([Ask PMQS].Status)=3) AND (([Ask PMQS].Date_Received) Is
Not
Null
And ([Ask PMQS].Date_Received) Between [Please enter start date] And
[Please
enter end date]));

:

Scotty,

Copy/Paste the SQL of the query here...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I am not sure what you mean by distinct but there is not any
grouping
in
the
query.

:

Scott,

Are you using DISTINCT in your query?

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina,

I first tried just pulling my report. Then clicked export and
tried
to
dump
data in excel 1997-2003 and the other version of excel. It
cut
off
probabbly
after 255 characters when it transfered it to excel.

I have tired the transferspreadsheet method but that did not
seem
to
work
for me. I was thinking there had to be an easier way then
what i
was
doing.
The only time it fully copied everything is when i transfered
the
query
to
XML. When i did that it kept my entire memo field. I do not
want
to
have
in
in XML since my end user really just needs it in excel.



:

Scott,

You say some of the text is cut off... Are you trying to
export
a
Memo
field? How much is some? How are you exporting...
TransferSpreadsheet?
Do
you have an Export Specification?

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Hi everyone,

I am using access 2003 and am trying to export a report
that
comes
from
a
query to excel however some of the text is cut off. I have
read
others
problems but couldnt find the shoe that fit. Can someone
help?
Can
i
have
some sort of marco that runs my query and then dumps it
into
excel
fully?
If
so please explain. Thanks for your help!

Scott


.



.



.



.
Click to expand...


.
Click to expand...
Click to expand...
 
Gina it looks like i finally got the query to transfer entirely. I do have
an issue when it transfers over the column that was greater than 255
charcters is showing up as ##################################. When i click
in the cell it shows me the content but i am still working on getting that
issue resolved. Thanks

Gina Whipp said:
Scott,

Okay, I am getting stumped becase as I said, I ran some tests and cannot
duplicate... Let's try this, what happens if you use TransferSpreadsheet on
the table? Also, copy/paste the TransferSpreadsheet line you are using
here.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

scott04 said:
Gina,

I am using excel 2003 as well...if i run the query all along i get all of
the data from the memo field. I do not get the data when i transfer or
export as it cuts at 255 characters. Using the mid function in the query
from (1, 255) then (256, 500) works but does not look nice since sometimes
words are cut up.

Gina Whipp said:
Scott,

Okay but is [[Ask PMQS] a query? And what version of Excel do you have,
you
said Access 2003 but not spedify Excel version? I have tried this using
TransferSpreadsheet and File|Export and have been successful both times,
whether I open in Excel 2003 or Excel 2007.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Actually it is the Question field the dept wanted a memo field.

:

Is it the Notes field that is the Memo field?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

SELECT [Ask PMQS].Status, [Ask PMQS].Date_Received, [Ask
PMQS].Topic,
[Ask
PMQS].[Question Category], [Ask PMQS].Question, [Ask PMQS].Answer,
[Ask
PMQS].[CRS Training/Help Site Resource], [Ask PMQS].Notes
FROM [Ask PMQS]
WHERE ((([Ask PMQS].Status)=3) AND (([Ask PMQS].Date_Received) Is
Not
Null
And ([Ask PMQS].Date_Received) Between [Please enter start date] And
[Please
enter end date]));

:

Scotty,

Copy/Paste the SQL of the query here...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I am not sure what you mean by distinct but there is not any
grouping
in
the
query.

:

Scott,

Are you using DISTINCT in your query?

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina,

I first tried just pulling my report. Then clicked export and
tried
to
dump
data in excel 1997-2003 and the other version of excel. It
cut
off
probabbly
after 255 characters when it transfered it to excel.

I have tired the transferspreadsheet method but that did not
seem
to
work
for me. I was thinking there had to be an easier way then
what i
was
doing.
The only time it fully copied everything is when i transfered
the
query
to
XML. When i did that it kept my entire memo field. I do not
want
to
have
in
in XML since my end user really just needs it in excel.



:

Scott,

You say some of the text is cut off... Are you trying to
export
a
Memo
field? How much is some? How are you exporting...
TransferSpreadsheet?
Do
you have an Export Specification?

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Hi everyone,

I am using access 2003 and am trying to export a report
that
comes
from
a
query to excel however some of the text is cut off. I have
read
others
problems but couldnt find the shoe that fit. Can someone
help?
Can
i
have
some sort of marco that runs my query and then dumps it
into
excel
fully?
If
so please explain. Thanks for your help!

Scott


.



.



.



.



.
Click to expand...
Click to expand...


.
Click to expand...
 
Scott,

First let me say, glad that got worked out! Now, as for the 255 character
limit (I assuming here you're talking about the column heading), that is an
Access limit so not sure how you are going to get around that. Any way you
can shorten those column headers?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

scott04 said:
Gina it looks like i finally got the query to transfer entirely. I do
have
an issue when it transfers over the column that was greater than 255
charcters is showing up as ##################################. When i
click
in the cell it shows me the content but i am still working on getting that
issue resolved. Thanks

Gina Whipp said:
Scott,

Okay, I am getting stumped becase as I said, I ran some tests and cannot
duplicate... Let's try this, what happens if you use TransferSpreadsheet
on
the table? Also, copy/paste the TransferSpreadsheet line you are using
here.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

scott04 said:
Gina,

I am using excel 2003 as well...if i run the query all along i get all
of
the data from the memo field. I do not get the data when i transfer or
export as it cuts at 255 characters. Using the mid function in the
query
from (1, 255) then (256, 500) works but does not look nice since
sometimes
words are cut up.

:

Scott,

Okay but is [[Ask PMQS] a query? And what version of Excel do you
have,
you
said Access 2003 but not spedify Excel version? I have tried this
using
TransferSpreadsheet and File|Export and have been successful both
times,
whether I open in Excel 2003 or Excel 2007.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Actually it is the Question field the dept wanted a memo field.

:

Is it the Notes field that is the Memo field?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

SELECT [Ask PMQS].Status, [Ask PMQS].Date_Received, [Ask
PMQS].Topic,
[Ask
PMQS].[Question Category], [Ask PMQS].Question, [Ask
PMQS].Answer,
[Ask
PMQS].[CRS Training/Help Site Resource], [Ask PMQS].Notes
FROM [Ask PMQS]
WHERE ((([Ask PMQS].Status)=3) AND (([Ask PMQS].Date_Received) Is
Not
Null
And ([Ask PMQS].Date_Received) Between [Please enter start date]
And
[Please
enter end date]));

:

Scotty,

Copy/Paste the SQL of the query here...

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I am not sure what you mean by distinct but there is not any
grouping
in
the
query.

:

Scott,

Are you using DISTINCT in your query?

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Gina,

I first tried just pulling my report. Then clicked export
and
tried
to
dump
data in excel 1997-2003 and the other version of excel. It
cut
off
probabbly
after 255 characters when it transfered it to excel.

I have tired the transferspreadsheet method but that did
not
seem
to
work
for me. I was thinking there had to be an easier way then
what i
was
doing.
The only time it fully copied everything is when i
transfered
the
query
to
XML. When i did that it kept my entire memo field. I do
not
want
to
have
in
in XML since my end user really just needs it in excel.



:

Scott,

You say some of the text is cut off... Are you trying to
export
a
Memo
field? How much is some? How are you exporting...
TransferSpreadsheet?
Do
you have an Export Specification?

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Hi everyone,

I am using access 2003 and am trying to export a report
that
comes
from
a
query to excel however some of the text is cut off. I
have
read
others
problems but couldnt find the shoe that fit. Can
someone
help?
Can
i
have
some sort of marco that runs my query and then dumps it
into
excel
fully?
If
so please explain. Thanks for your help!

Scott


.



.



.



.



.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top