Import Data from word bookmarks using sql? 
Author Message
 Import Data from word bookmarks using sql?

I have a word document questionnaire without at least 200 bookmarks
and more formfields.

I'm using a routine stored inside a class module to get hold of a
number of these documents and to retrieve the data into Access one at
a time.

I had thought that this may be possible using an ADO connection to
Word, but cannot find any material on this method (so I suspect its
unsupported).  I want this to be a simple as possible as I have many
other types of questionnaires that I have to run similar routines
with.

I had also wanted to store the sql string for this type of
questionnaire and my plan was to store the string (which is likely to
be very long) in a table, and to retrieve this string (an insert into
command) when the ADO connection was setup.

Is this possible?  Or do I have to use another method?  If so, can
anyone advise me as to which method(s) to use?

Any help greatly appreciated.

Richard



Sat, 15 May 2004 01:32:45 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Importing Outlook data into a Word Table - using view control

2. Importing Outlook Data to a Word Table using a view control

3. Importing data using Access 2000 and SQL 7

4. Import XML data into SQL using VB

5. Import XML data into SQL using VB

6. importing and exporting data using sql server and vb

7. Import XML data into SQL using VB

8. Using VB5 to import data to access without using the Data control

9. Getting SQL Data Into Word Using a Web Page

10. sending bookmark data from word 97 to access 97 database

11. Word 2K Add text to bookmarks using Input Box

12. Writing to word using bookmarks

 

 
Powered by phpBB® Forum Software