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
|
|||
|
|||
Select Table Dialog Box
Hi,
When I am trying to grab data from an excel file to merge into Word I follow the usual steps, but at one point I get a Select Table dialog box which is blank. I cannot seem to proceed beyond that. I've been able to find some info. on the Knowledge Base Article #289830 which seems to be very close to my situation. The article mentions that a possible solution would be to force Word to use DDE instead of OLEDB: "Force Word 2002 to use DDE instead of OLEDB for the data access by supplying the SubType argument of the OpenDataSource method with wdMergeSubTypeWord2000. Note that the SubType argument is new to Word 2002; Word 97 and Word 2000 do not support this argument." I'm not sure how to go about doing this, anyone have any ideas? Thanks. Ravi |
#2
|
|||
|
|||
From the Tools menu, select Options and on the General tab, check the box
for "Confirm conversions at Open". When you then go to attach the datasource, you will be given a choice of which connection method to use. -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "Ravi" wrote in message ... Hi, When I am trying to grab data from an excel file to merge into Word I follow the usual steps, but at one point I get a Select Table dialog box which is blank. I cannot seem to proceed beyond that. I've been able to find some info. on the Knowledge Base Article #289830 which seems to be very close to my situation. The article mentions that a possible solution would be to force Word to use DDE instead of OLEDB: "Force Word 2002 to use DDE instead of OLEDB for the data access by supplying the SubType argument of the OpenDataSource method with wdMergeSubTypeWord2000. Note that the SubType argument is new to Word 2002; Word 97 and Word 2000 do not support this argument." I'm not sure how to go about doing this, anyone have any ideas? Thanks. Ravi |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Semicolon delimited text query help | Al Guerra | Running & Setting Up Queries | 3 | August 12th, 2004 11:50 AM |
select multiple objects dialog in PPT (2002) | gchutrau | Powerpoint | 1 | July 24th, 2004 02:35 AM |
Complicated Databse w/many relationships | Søren | Database Design | 7 | July 13th, 2004 05:41 AM |
Select Table Fields for Export | [email protected] | General Discussion | 2 | June 17th, 2004 12:59 PM |
Populating mail merge doc with data from MSsql 2K table | Sydney Lotterby | Mailmerge | 4 | May 17th, 2004 08:03 PM |