Trying to Export Report to Excel 2003

scott04 · External Since: Nov 07, 2006 Posts: 14

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 Whipp · External Since: Sep 25, 2003 Posts: 426

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" <scott04.RemoveThis@discussions.microsoft.com> wrote in message
news:10C5D7B7-D167-4BC6-85D8-DFEC9019D448@microsoft.com...
> 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

scott04 · External Since: Nov 07, 2006 Posts: 14

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" <scott04 RemoveThis @discussions.microsoft.com> wrote in message
> news:10C5D7B7-D167-4BC6-85D8-DFEC9019D448@microsoft.com...
> > 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 Whipp · External Since: Sep 25, 2003 Posts: 426

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" <scott04 RemoveThis @discussions.microsoft.com> wrote in message
news:168099EB-1324-4246-B497-6A931BAB0C1F@microsoft.com...
> 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" <scott04 RemoveThis @discussions.microsoft.com> wrote in message
>> news:10C5D7B7-D167-4BC6-85D8-DFEC9019D448@microsoft.com...
>> > 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
>>
>>
>> .
>>

scott04 · External Since: Nov 07, 2006 Posts: 14

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" <scott04 DeleteThis @discussions.microsoft.com> wrote in message
> news:168099EB-1324-4246-B497-6A931BAB0C1F@microsoft.com...
> > 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" <scott04 DeleteThis @discussions.microsoft.com> wrote in message
> >> news:10C5D7B7-D167-4BC6-85D8-DFEC9019D448@microsoft.com...
> >> > 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 Whipp · External Since: Sep 25, 2003 Posts: 426

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" <scott04.RemoveThis@discussions.microsoft.com> wrote in message
news:168099EB-1324-4246-B497-6A931BAB0C1F@microsoft.com...
> 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" <scott04.RemoveThis@discussions.microsoft.com> wrote in message
>> news:10C5D7B7-D167-4BC6-85D8-DFEC9019D448@microsoft.com...
>> > 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 Whipp · External Since: Sep 25, 2003 Posts: 426

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" <scott04 DeleteThis @discussions.microsoft.com> wrote in message
news:D26AF582-4896-471B-B205-F7D13E8D7683@microsoft.com...
>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" <scott04 DeleteThis @discussions.microsoft.com> wrote in message
>> news:168099EB-1324-4246-B497-6A931BAB0C1F@microsoft.com...
>> > 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" <scott04 DeleteThis @discussions.microsoft.com> wrote in message
>> >> news:10C5D7B7-D167-4BC6-85D8-DFEC9019D448@microsoft.com...
>> >> > 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
>> >>
>> >>
>> >> .
>> >>
>>
>>
>> .
>>

scott04 · External Since: Nov 07, 2006 Posts: 14

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" <scott04.RemoveThis@discussions.microsoft.com> wrote in message
> news:D26AF582-4896-471B-B205-F7D13E8D7683@microsoft.com...
> >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" <scott04.RemoveThis@discussions.microsoft.com> wrote in message
> >> news:168099EB-1324-4246-B497-6A931BAB0C1F@microsoft.com...
> >> > 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" <scott04.RemoveThis@discussions.microsoft.com> wrote in message
> >> >> news:10C5D7B7-D167-4BC6-85D8-DFEC9019D448@microsoft.com...
> >> >> > 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 Whipp · External Since: Sep 25, 2003 Posts: 426

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" <scott04 RemoveThis @discussions.microsoft.com> wrote in message
news:2ADFEB99-DED7-45E1-A657-0B8C95A3436A@microsoft.com...
> 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" <scott04 RemoveThis @discussions.microsoft.com> wrote in message
>> news:D26AF582-4896-471B-B205-F7D13E8D7683@microsoft.com...
>> >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" <scott04 RemoveThis @discussions.microsoft.com> wrote in message
>> >> news:168099EB-1324-4246-B497-6A931BAB0C1F@microsoft.com...
>> >> > 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" <scott04 RemoveThis @discussions.microsoft.com> wrote in message
>> >> >> news:10C5D7B7-D167-4BC6-85D8-DFEC9019D448@microsoft.com...
>> >> >> > 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
>> >> >>
>> >> >>
>> >> >> .
>> >> >>
>> >>
>> >>
>> >> .
>> >>
>>
>>
>> .
>>

scott04 · External Since: Nov 07, 2006 Posts: 14

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

"Gina Whipp" wrote:

> 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" <scott04.TakeThisOut@discussions.microsoft.com> wrote in message
> news:2ADFEB99-DED7-45E1-A657-0B8C95A3436A@microsoft.com...
> > 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" <scott04.TakeThisOut@discussions.microsoft.com> wrote in message
> >> news:D26AF582-4896-471B-B205-F7D13E8D7683@microsoft.com...
> >> >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" <scott04.TakeThisOut@discussions.microsoft.com> wrote in message
> >> >> news:168099EB-1324-4246-B497-6A931BAB0C1F@microsoft.com...
> >> >> > 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" <scott04.TakeThisOut@discussions.microsoft.com> wrote in message
> >> >> >> news:10C5D7B7-D167-4BC6-85D8-DFEC9019D448@microsoft.com...
> >> >> >> > 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 Whipp · External Since: Sep 25, 2003 Posts: 426

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" <scott04 RemoveThis @discussions.microsoft.com> wrote in message
news:2ADFEB99-DED7-45E1-A657-0B8C95A3436A@microsoft.com...
> 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" <scott04 RemoveThis @discussions.microsoft.com> wrote in message
>> news:D26AF582-4896-471B-B205-F7D13E8D7683@microsoft.com...
>> >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" <scott04 RemoveThis @discussions.microsoft.com> wrote in message
>> >> news:168099EB-1324-4246-B497-6A931BAB0C1F@microsoft.com...
>> >> > 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" <scott04 RemoveThis @discussions.microsoft.com> wrote in message
>> >> >> news:10C5D7B7-D167-4BC6-85D8-DFEC9019D448@microsoft.com...
>> >> >> > 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
>> >> >>
>> >> >>
>> >> >> .
>> >> >>
>> >>
>> >>
>> >> .
>> >>
>>
>>
>> .
>>

scott04 · External Since: Nov 07, 2006 Posts: 14

It is a table

"Gina Whipp" wrote:

> Another question... is Ask PMQS a table or query? If it is a query what is
> the SQL of that query?
>
> --
> Gina Whipp

Gina Whipp · External Since: Sep 25, 2003 Posts: 426

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" <scott04.DeleteThis@discussions.microsoft.com> wrote in message
news:067E8838-D3BD-4CD5-B1FC-B735EC2DB275@microsoft.com...
> Actually it is the Question field the dept wanted a memo field.
>
> "Gina Whipp" wrote:
>
>> 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" <scott04.DeleteThis@discussions.microsoft.com> wrote in message
>> news:2ADFEB99-DED7-45E1-A657-0B8C95A3436A@microsoft.com...
>> > 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" <scott04.DeleteThis@discussions.microsoft.com> wrote in message
>> >> news:D26AF582-4896-471B-B205-F7D13E8D7683@microsoft.com...
>> >> >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" <scott04.DeleteThis@discussions.microsoft.com> wrote in message
>> >> >> news:168099EB-1324-4246-B497-6A931BAB0C1F@microsoft.com...
>> >> >> > 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" <scott04.DeleteThis@discussions.microsoft.com> wrote in message
>> >> >> >> news:10C5D7B7-D167-4BC6-85D8-DFEC9019D448@microsoft.com...
>> >> >> >> > 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
>> >> >> >>
>> >> >> >>
>> >> >> >> .
>> >> >> >>
>> >> >>
>> >> >>
>> >> >> .
>> >> >>
>> >>
>> >>
>> >> .
>> >>
>>
>>
>> .
>>

scott04 · External Since: Nov 07, 2006 Posts: 14

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

> 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" <scott04 RemoveThis @discussions.microsoft.com> wrote in message
> news:067E8838-D3BD-4CD5-B1FC-B735EC2DB275@microsoft.com...
> > Actually it is the Question field the dept wanted a memo field.
> >
> > "Gina Whipp" wrote:
> >
> >> 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" <scott04 RemoveThis @discussions.microsoft.com> wrote in message
> >> news:2ADFEB99-DED7-45E1-A657-0B8C95A3436A@microsoft.com...
> >> > 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" <scott04 RemoveThis @discussions.microsoft.com> wrote in message
> >> >> news:D26AF582-4896-471B-B205-F7D13E8D7683@microsoft.com...
> >> >> >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" <scott04 RemoveThis @discussions.microsoft.com> wrote in message
> >> >> >> news:168099EB-1324-4246-B497-6A931BAB0C1F@microsoft.com...
> >> >> >> > 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" <scott04 RemoveThis @discussions.microsoft.com> wrote in message
> >> >> >> >> news:10C5D7B7-D167-4BC6-85D8-DFEC9019D448@microsoft.com...
> >> >> >> >> > 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 Whipp · External Since: Sep 25, 2003 Posts: 426

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" <scott04 DeleteThis @discussions.microsoft.com> wrote in message
news:C3317A91-E73A-43A8-AFE1-AE68991A0529@microsoft.com...
> 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" wrote:
>
>> 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" <scott04 DeleteThis @discussions.microsoft.com> wrote in message
>> news:067E8838-D3BD-4CD5-B1FC-B735EC2DB275@microsoft.com...
>> > Actually it is the Question field the dept wanted a memo field.
>> >
>> > "Gina Whipp" wrote:
>> >
>> >> 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" <scott04 DeleteThis @discussions.microsoft.com> wrote in message
>> >> news:2ADFEB99-DED7-45E1-A657-0B8C95A3436A@microsoft.com...
>> >> > 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" <scott04 DeleteThis @discussions.microsoft.com> wrote in message
>> >> >> news:D26AF582-4896-471B-B205-F7D13E8D7683@microsoft.com...
>> >> >> >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" <scott04 DeleteThis @discussions.microsoft.com> wrote in message
>> >> >> >> news:168099EB-1324-4246-B497-6A931BAB0C1F@microsoft.com...
>> >> >> >> > 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" <scott04 DeleteThis @discussions.microsoft.com> wrote in
>> >> >> >> >> message
>> >> >> >> >> news:10C5D7B7-D167-4BC6-85D8-DFEC9019D448@microsoft.com...
>> >> >> >> >> > 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
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >> .
>> >> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >> .
>> >> >> >>
>> >> >>
>> >> >>
>> >> >> .
>> >> >>
>> >>
>> >>
>> >> .
>> >>
>>
>>
>> .
>>

scott04 · External Since: Nov 07, 2006 Posts: 14

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

> 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" <scott04.TakeThisOut@discussions.microsoft.com> wrote in message
> news:C3317A91-E73A-43A8-AFE1-AE68991A0529@microsoft.com...
> > 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" wrote:
> >
> >> 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" <scott04.TakeThisOut@discussions.microsoft.com> wrote in message
> >> news:067E8838-D3BD-4CD5-B1FC-B735EC2DB275@microsoft.com...
> >> > Actually it is the Question field the dept wanted a memo field.
> >> >
> >> > "Gina Whipp" wrote:
> >> >
> >> >> 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" <scott04.TakeThisOut@discussions.microsoft.com> wrote in message
> >> >> news:2ADFEB99-DED7-45E1-A657-0B8C95A3436A@microsoft.com...
> >> >> > 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" <scott04.TakeThisOut@discussions.microsoft.com> wrote in message
> >> >> >> news:D26AF582-4896-471B-B205-F7D13E8D7683@microsoft.com...
> >> >> >> >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" <scott04.TakeThisOut@discussions.microsoft.com> wrote in message
> >> >> >> >> news:168099EB-1324-4246-B497-6A931BAB0C1F@microsoft.com...
> >> >> >> >> > 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" <scott04.TakeThisOut@discussions.microsoft.com> wrote in
> >> >> >> >> >> message
> >> >> >> >> >> news:10C5D7B7-D167-4BC6-85D8-DFEC9019D448@microsoft.com...
> >> >> >> >> >> > 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 Whipp · External Since: Sep 25, 2003 Posts: 426

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" <scott04 DeleteThis @discussions.microsoft.com> wrote in message
news:E67F904E-8E87-47E2-AC6A-D0E60387FE48@microsoft.com...
> 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" wrote:
>
>> 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" <scott04 DeleteThis @discussions.microsoft.com> wrote in message
>> news:C3317A91-E73A-43A8-AFE1-AE68991A0529@microsoft.com...
>> > 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" wrote:
>> >
>> >> 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" <scott04 DeleteThis @discussions.microsoft.com> wrote in message
>> >> news:067E8838-D3BD-4CD5-B1FC-B735EC2DB275@microsoft.com...
>> >> > Actually it is the Question field the dept wanted a memo field.
>> >> >
>> >> > "Gina Whipp" wrote:
>> >> >
>> >> >> 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" <scott04 DeleteThis @discussions.microsoft.com> wrote in message
>> >> >> news:2ADFEB99-DED7-45E1-A657-0B8C95A3436A@microsoft.com...
>> >> >> > 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" <scott04 DeleteThis @discussions.microsoft.com> wrote in message
>> >> >> >> news:D26AF582-4896-471B-B205-F7D13E8D7683@microsoft.com...
>> >> >> >> >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" <scott04 DeleteThis @discussions.microsoft.com> wrote in
>> >> >> >> >> message
>> >> >> >> >> news:168099EB-1324-4246-B497-6A931BAB0C1F@microsoft.com...
>> >> >> >> >> > 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" <scott04 DeleteThis @discussions.microsoft.com> wrote in
>> >> >> >> >> >> message
>> >> >> >> >> >> news:10C5D7B7-D167-4BC6-85D8-DFEC9019D448@microsoft.com...
>> >> >> >> >> >> > 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
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >> .
>> >> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >> .
>> >> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >> .
>> >> >> >>
>> >> >>
>> >> >>
>> >> >> .
>> >> >>
>> >>
>> >>
>> >> .
>> >>
>>
>>
>> .
>>