Mike....
Thanks Mike for your reply! :)
>>Also...
>>Have you looked at SQLCONNECT() and SQLEXEC()?
Yes... some others have recommended this and I am playing with it. I'm using this project to learn about connection....views...odbc...etc. Never had much experience with it and need to work out. Slowly it is coming into focus. :)
I was having initial trouble with all the various methods working only to find out that the Access table (created from a VFP table) had a field named... date... which worked fine in VFP but made the code to pass data to the Access table hang. Anyway.... once I got that correctd it all seemed to work.
>>You can also use ADO recordsets as a go between, but in this case it sounds like more work than it's worth.
Actually..... Before I got the other stuff to work I started playing around with using DAO (in a VB ActiveX dll file) to transfer that data and got it to work pretty well and it was reasonably fast. I'm sure ADO would be even faster.
Anyway, thanks again for your response.
Tom Gahagan
Alliance
Computer Solutions
"Music, like sex, is much too important to be left to professionals."
Robert Shaw