>I am looking for an alternative that allows merging from word 97 to a vfp 6.0 database. i do not like msquery as the limit of 255 characters is too easy to use up. right now, i merge the vfp data into excel using msquery, and then merge the word 97 document to the excel document (excel has no limit of 255 characters as does word). unfortunately, this takes a while to take place.
>
>i have also selected the merge information from the database table into a free table, and then merge into this free table using the VFP foxpro driver. unfortunately, in a multiuser environment, this doesn't work well as anytime this select statement is utilized (ie select ... from table into table table name), another user cannot run the same program (receive error "file is in use").
>
>Any help (even third party recommendations) will be appreciated. thank you.

Paul,
Which 255 limit ? 255 limit on SQL ? If so there are 2 SQL strings each with a limit of 255.
On a multiuser environment you could use free table approach if you name your files unique (ie: 'F'+right(sys(2015),7)).
Cetin