>Excuse me. I feel a little bit shame because I can't use odbc to update a vfp table by Excel. (What's wrong of me!?)
>
>I am using Excel97 to retrieve external database for updating a vfp table. The retriving procedure was very successful. Then, I update the records. No problem. But when I save it by 'Save' button, Excel hasn't update my vfp table at the same time.

What I understand is you can get set of data from VFP database or table using Excel's Get External Data option, but to update it using Cells, I think it is not possible because the data sheet is not physically attached or connected into it. Meaning, what you are updating is not the physical data of VFP table but the data sheet which is totally a separate file and was just converted through the query engine of Excel. Although I am not so sure if there is a possible solution, maybe by Macro programming, but as far as our projects are concern, we do use Offline View which we knew it is the definite solution as of todate. Sometimes the export/import features of VFP will also do, but again depending on your requirements.


>
>Sorry, bother you again.
>
>(We are not only have good Chinese Food, also have very good Philipino Food, Japanese Food, Korean Food,..... You can eat(not walk) around the world.)
>
>Sunny
>
>>>If you come here, please let me know. I swear I am a good guide if you don't mind my poor English.:)
>>>
>>>Sunny
>>
>>Your English is just the same as mine. It sounds like Foxpro Language which is much clearer than Assembly or C... :<)
>>
>>>
>>>>>Thanks a lot. Will you come to Hong Kong later? May I buy you a dinner for my thankfulness?
>>>>>
>>>>>Sunny
>>>>>
>>>>
>>>>Thanks in advance! Chinese foods are really great. We just went there last February 18-20, 1998, and I do not know when will be the next trip. Maybe I'll just inform you by e-mail, not because of the dinner (better if there is, just kidding..), but rather I want to have some friends their in Hongkong.
>>>>
>>>>>>>Could you tell me how to reset the view parameters?
>>>>>>
>>>>>>Sunny,
>>>>>>
>>>>>>What Mike is saying is applicable only if your view is parameterized. But a remote view (source of the offline view) cannot be repopulated unless you drop the offline view first using DROPOFFLINE().
>>>>>>
>>>>>>Resetting view parameter is as simple as changing the value of the variable you used.
>>>>>>
>>>>>>prefdate = "any_value"
>>>>>>=REQUERY("myview")
>>>>>>
>>>>>>where: prefdate is the view parameter you declared at FILTER tab portion upond defining your SQL view.
>>>>>>
>>>>>>Your View SQL statement should be like this:
>>>>>>
>>>>>>SELECT mytable.field1, etc. FROM mytable WHERE mytable.field1 = ?prefdate
>>>>>>
>>>>>>declare your prefdate variable as PUBLIC then initialize it to avoid asking you to enter a value of prefdate upon execution.
>>>>>>
>>>>>>>>>Now, I know the way to use offline view and update SQL server database. However, I am still looking for the way to update remote view which is store inside the user's workstation. Should I create the remote view and offline view again, shouldn't I?
>>>>>>>>>
>>>>>>>>>Sunny
>>>>>>>>
>>>>>>>>Sunny,
>>>>>>>>
>>>>>>>>It's my understanding that once the offline view is placed online (with the USE command) it becomes just a regular every-day remote view. If you want to repopulate it, reset your view parameters and issue a REQUERY(). Then you can take the view offline again.
>>>>>>>>
>>>>>>>>-Mike