General information
Category:
Coding, syntax & commands
Title:
Link Excel cells to VFP fields
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only