Forum: Visual FoxPro Category: COM/DCOM and OLE Automation Title: Re: ODBC and MailMerge, Excel question Thread #506833 Message #507224
From 05/15/2001 09:03:14
Sanjay Kapoor #013639
Sita
London
To 05/14/2001 11:15:57
Brenda Grossnickle #021961
SunTrust Bank / ASD
Lake Mary, Florida

>>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.


>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.

I looked at the http://www.microsoft.com/data/download.htm and saw many MDAC components but am not clear as to what I need to download and install. I want to make as small a change as possible on their machine. When I installed the new MDAC it actually excluded FoxPro drivers. Can you point me in the right direction?

Brenda