Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Link Excel cells to VFP fields
Message
From
09/05/2003 08:33:48
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Link Excel cells to VFP fields
Miscellaneous
Thread ID:
00786712
Message ID:
00786712
Views:
42
I have no experience with linking VFP and Excel and would appreciate any help or advice on how to set this up.

In Excel we have a fairly lengthy worksheet that contains this section:

........... Jan ...... Feb ...... Mar
BMW...... 300 ...... 310 ...... 290
Merc.......105 ....... 125 ....... 110


In VFP we have records:

cItem .... cMonth ...... nQty
BMW ...... Jan ...... 300
BMW ...... Feb ...... 310
BMW ...... Mar ...... 290
Merc ...... Jan ...... 105
Merc ...... Feb ...... 125
Merc ...... Mar ...... 110

Now user wants to update her Excel spreadsheet and then get the VFP table to be updated automatically. What is the best way to do this?

TIA
Next
Reply
Map
View

Click here to load this message in the networking platform