Cindy,
I have a couple of processes that copy a spreadsheet to a dbf on a nightly basis. Would you like a copy of my code? One of the spread sheets has a password and OLE and excel and VFP and passwords don't seem to get along, so I have to jump through a couple of hopes. Having said that, both of the prg's are very short.
>>>Fred,
>>>
>>>What works best for the reverse - selecting a bunch of cells in Excel and copying the rows into a table or an array?
>>>
>>>Do you just make a string and look for the tabs to parse into data?
>>>
>>>>
>>>>Check out _VFP.DataToClip() and Paste in Excel and tell me if you still think it's slow.
>>
>>Cindy,
>>
>>I've never had a need to go the other way, but that sounds like it will work. Doesn't Excel have the ability to send data directly to .DBF's? I don't do a whole lot with Excel, I've really just played with it.
>
>I was thinking to copy some selected cells, but If I copy to CSV and append the whole thing to a cursor, and then pick out what I want (using VAL(), etc. to change from char to Num) that should work.
>
>Thanks for helping me brainstorm. ;-)
Michael Helms
May the Schwartz be with you.<(©¿©)> -- Mel Brooks
"Someday, and that day may never come, you will be called upon to perform a service" -- Vito Corleone
"Live like there is no tomorrow, Dance like no one is watching, Love like you've never been hurt." -- Anonymous
"I'm thinking about joining the campaign for shorter tag lines." -- Me