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. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|