Reply
 
Thread Tools Display Modes
  #1   Report Post  
Chris Schilling
 
Posts: n/a
Default Issue when querying excel 2003 to merge into word 2003

I have a co-worker having an issue with merging excel data into word and
querying the data for specific information (both 2003 versions). When she
does this, the first record is always the first line of data (even though
the query should be excluding this line). It then skips the record that
should be the first record of the query results, and after that the results
are correct. She also said that she knows another person that had the same
issue. Anyone have any ideas what might be causing this?

Thanks,
Chris
  #2   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi Chris,

I have a co-worker having an issue with merging excel data into word and
querying the data for specific information (both 2003 versions). When she
does this, the first record is always the first line of data (even though
the query should be excluding this line). It then skips the record that
should be the first record of the query results, and after that the results
are correct. She also said that she knows another person that had the same
issue.

Never heard of this before, but a bit more information might help

1. What is the query?

2. How is the query being set (exact steps)?

3. Does this happen if the Excel data is linked into a new Word document (as a
test)?

4. If the Excel data copied and pasted into a Word document (assuming it
contains 64 columns or less) and the merge is linked to the Word document as
the data source, does the query work correctly?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

  #3   Report Post  
Chris Schilling
 
Posts: n/a
Default

Thanks for your response -- I don't have exact answers to your questions,
but I have more information (which ends up being even more confusing). I
walked through the mail merge wizard with some files she sent me, and the
query worked fine for me (it's basically a sales report "form letter" in
which we were querying for a specific sales district). When I mentioned
this to my co-worker, she tried the wizard and it also worked -- previously
she was using the mail merge helper (which she happens to prefer using). So
I tried the mail merge helper (after I found it buried in the toolbar
customizations -- I guess there may be a reason it's not easy to find :-)),
and I get the same erroneous results that she was getting. Could the helper
possibly be broken?

Chris

"Cindy M -WordMVP-" wrote in message
news:VA.0000a3a5.0098da9d@speedy...
Hi Chris,

I have a co-worker having an issue with merging excel data into word and
querying the data for specific information (both 2003 versions). When
she
does this, the first record is always the first line of data (even though
the query should be excluding this line). It then skips the record that
should be the first record of the query results, and after that the
results
are correct. She also said that she knows another person that had the
same
issue.

Never heard of this before, but a bit more information might help

1. What is the query?

2. How is the query being set (exact steps)?

3. Does this happen if the Excel data is linked into a new Word document
(as a
test)?

4. If the Excel data copied and pasted into a Word document (assuming it
contains 64 columns or less) and the merge is linked to the Word document
as
the data source, does the query work correctly?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)



  #4   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi Chris,

Most people have no problem using the older technology (the MM Helper) with
Excel or Access. There are, however, traditionally problems between Word and
Excel using the older technology (DDE connection instead of ODBC or OLEDB) if
either the Word document or the Excel workbook is slightly damaged. (The
reasoning behind most of my questions) My guess would be that this is the case,
in this particular instance.

I don't have exact answers to your questions,
but I have more information (which ends up being even more confusing). I
walked through the mail merge wizard with some files she sent me, and the
query worked fine for me (it's basically a sales report "form letter" in
which we were querying for a specific sales district). When I mentioned
this to my co-worker, she tried the wizard and it also worked -- previously
she was using the mail merge helper (which she happens to prefer using). So
I tried the mail merge helper (after I found it buried in the toolbar
customizations -- I guess there may be a reason it's not easy to find :-)),
and I get the same erroneous results that she was getting. Could the helper
possibly be broken?


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 5th 05 11:23 PM
Word 2003 and Access 2003 Mail Merge question HD87glide Microsoft Word Help 2 December 15th 04 02:29 PM
How to update 2003 Word Doc for 2004 with Excel list Dennis Microsoft Word Help 1 December 4th 04 08:06 AM
Exchange 2003 - Outlook 2003 - Word 2003 mail merge Micheline Mailmerge 1 December 2nd 04 11:51 AM
How do you set up a label mail merge with Excel as source in 2003. Psychic Mom Mailmerge 1 November 27th 04 03:03 PM


All times are GMT +1. The time now is 02:38 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"