>I have to fill out a service request to have my app set up in a training room. I wanted Win95, Excel97, Word97. That was easy but I got stuck on the ODBC issue of what was required on the desktop.
>
>I issue a "goWordApp = createobject("Word.Application")" and several other statements to do a Word MailMerge. The MailMerge data source is a dbf free table.
>
>I also do a "oExcel = CREATEOBJECT('Excel.Application')" and then "oExcel.ActiveCell.Value = lvalue".
>
>Obviously the MailMerge uses ODBC, but what specifically. Does the Excel use ODBC? and What should I tell the installation people that I need to assure that my Word MailMerge and my Excel Create procedures work properly.
>
>Thanks
>
>Brenda
Brenda,
From what I could gather, you require an ODBC driver for VFP. It is available to download from Microsoft. This will allow you to access both .DBC and .DBF extensions. Create a Data Source through Control Panel. This will be the data source required by Word, or any other application.
I am not sure what you're doing with Excel. If your 'lvalue' is in a loop trying to get data from the same .dbf table you refer to, the same DSN which you created will work.
Cheers,
Sanjay Kapoor
Relatively speaking is a conversation with Einstein