microsoft.public.word.vba.general

Hi Nam,

Assuming Access isn't installed on the client machine, take a look at XML -
might be a good alternative for you. Another alternative would be to create
your own csv file format - append the Word doc sentences to that csv file
along with a timestamp, maybe the full doc name, and some sort of key
column - maybe a roll-your-own autonumber. You could link to that csv from
Access and update whatever tables as appropriate querying the data from that
record source. This isn't as complicated as it sounds - if you are far
enough into VBA to create Add-Ins for clients, then you can probably handle
the file management code.

If Access is installed on the client machine then you can use the Access
Application object to open the database, insert your data where you wish,
and close the database from VBA code running in Word.

Hope this helps,
Gordon




"Nam" wrote in message
news:99D1B94A-8DC3-4686-8077-A981B44BD7C7@microsoft.com...
> I am developing an MS Word 200 Add-In that requires collecting certain
> sentences from MS Word document and storing it into MS Access 2000. I
> would
> like to achieve this task without worrying about installing (or
> registering)
> DAO or ADO etc on the client’s machine. Does MS office have a built-in
> data
> migration functionality that I can use in my VBA macros?
>
> Thanks in Advance,
> Nam