Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing Data

Status
Not open for further replies.

randy700

Programmer
Sep 25, 2003
2,384
US
Hope this is the right forum.

In an attempt to gather data for my tables, I have received numerous MS-Word forms that have information in text boxes and drop down boxes.

How can I link to these forms (extension is .doc) to import the data?


Randy
 
Hi,

I don't think that you can. I think that you SHOULD have linked one Word doc to a database and THEN allowed users to add their info.

I'm interested as to how you allowed users to add information to 'drop-down' boxes in Word anyway.

You would be better designing a simple app. in Access, placing it on the network and releasing it to your users to fill in.

If that isn't possible, then same app with a CSV file export facility, and distribute it to individual users.
They can then send you the CSV to import into your db.

Regards,

Darrylle




Never argue with an idiot, he'll bring you down to his level - then beat you with experience. darrylles@yahoo.co.uk
 
To link to something you need an ODBC driver (alternatively maybe OLE DB) so have a look for that, althought I doubt there is one for Word.

Word can be called from Access and its object model must let you get at everything but I'd maybe try another forum for the details.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top