Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
[email protected] spy_234432@yahoo.com is offline
external usenet poster
 
Posts: 1
Default Unable to open data source

This is not a mailmerge question, but I thought that someone might be
able to help since I have seen similar questions here. I am trying to
pull information out of an Access database into my word doc.

This won't work

{ DATABASE \d "C:\\mckdata\\June2006.mdb" \c "DSN=MS Access Database;
DBQ=C:\\mckdata\\June2006.mdb" \s "select Priority from
\"case_summary_table\" }

But this will

{ DATABASE \d "C:\\mckdata\\June2006.mdb" \c "DSN=MS Access Database;
DBQ=C:\\mckdata\\June2006.mdb" \s "select * from \"case_summary_table
\" }

The difference in the second one is that I am querying all of the
fields in the table.

Thanks in advance for your help.

 
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
trouble with mail merge, word was unable to open data source edie Mailmerge 2 May 10th 06 04:46 PM
Word was unable to open the data source. Michael Suttkus, II Mailmerge 3 November 16th 05 02:29 PM
Unable to open excel data source for word mail merge Trisha Microsoft Word Help 0 October 18th 05 10:59 AM
Unable to change data source [email protected] Mailmerge 0 October 12th 05 06:02 PM
"Word was unable to open the Excel data source" Asp.net Mailmerge Shalini Mailmerge 8 June 23rd 05 02:09 AM


All times are GMT +1. The time now is 04:59 AM.

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

About Us

"It's about Microsoft Word"