A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Trying to Export Report to Excel 2003



 
 
Thread Tools Display Modes
  #1  
Old October 27th, 2009, 03:27 PM posted to microsoft.public.access.reports
scott04
external usenet poster
 
Posts: 197
Default Trying to Export Report to Excel 2003

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
  #2  
Old October 28th, 2009, 12:26 AM posted to microsoft.public.access.reports
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Trying to Export Report to Excel 2003

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

"scott04" wrote in 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



  #3  
Old October 28th, 2009, 02:11 PM posted to microsoft.public.access.reports
scott04
external usenet poster
 
Posts: 197
Default Trying to Export Report to Excel 2003

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.



"Gina Whipp" wrote:

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

"scott04" wrote in 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



.

  #4  
Old October 28th, 2009, 05:46 PM posted to microsoft.public.access.reports
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Trying to Export Report to Excel 2003

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

"scott04" wrote in 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.



"Gina Whipp" wrote:

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

"scott04" wrote in 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



.



  #5  
Old October 28th, 2009, 05:47 PM posted to microsoft.public.access.reports
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Trying to Export Report to Excel 2003

OR Group By...

--
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" wrote in 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.



"Gina Whipp" wrote:

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

"scott04" wrote in 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



.



  #6  
Old October 28th, 2009, 07:10 PM posted to microsoft.public.access.reports
scott04
external usenet poster
 
Posts: 197
Default Trying to Export Report to Excel 2003

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

"Gina Whipp" wrote:

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

"scott04" wrote in 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.



"Gina Whipp" wrote:

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

"scott04" wrote in 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


.



.

  #7  
Old October 28th, 2009, 07:26 PM posted to microsoft.public.access.reports
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Trying to Export Report to Excel 2003

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

"scott04" wrote in message
news
I am not sure what you mean by distinct but there is not any grouping in
the
query.

"Gina Whipp" wrote:

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

"scott04" wrote in 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.



"Gina Whipp" wrote:

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

"scott04" wrote in 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


.



.



  #8  
Old October 29th, 2009, 05:50 PM posted to microsoft.public.access.reports
scott04
external usenet poster
 
Posts: 197
Default Trying to Export Report to Excel 2003

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" wrote:

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

"scott04" wrote in message
news
I am not sure what you mean by distinct but there is not any grouping in
the
query.

"Gina Whipp" wrote:

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

"scott04" wrote in 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.



"Gina Whipp" wrote:

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

"scott04" wrote in 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


.



.



.

  #9  
Old October 29th, 2009, 06:11 PM posted to microsoft.public.access.reports
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Trying to Export Report to Excel 2003

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" wrote in message
...
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" wrote:

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

"scott04" wrote in message
news
I am not sure what you mean by distinct but there is not any grouping in
the
query.

"Gina Whipp" wrote:

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

"scott04" wrote in 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.



"Gina Whipp" wrote:

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

"scott04" wrote in 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


.



.



.



  #10  
Old October 29th, 2009, 06:19 PM posted to microsoft.public.access.reports
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Trying to Export Report to Excel 2003

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" wrote in message
...
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" wrote:

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

"scott04" wrote in message
news
I am not sure what you mean by distinct but there is not any grouping in
the
query.

"Gina Whipp" wrote:

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

"scott04" wrote in 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.



"Gina Whipp" wrote:

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

"scott04" wrote in 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


.



.



.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:24 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.