Michael,

I've done enough APPEND FROM's within Fox, and some simple OLE.

What I'm after is a way to pick data out of the middle of the spreadsheet where there will otherwise be text in numeric columns, etc. And the number of lines I will need to get will be variable.

The spreadsheet will have a bunch of data about an employee like name.
There will be a couple of rows which contain "column headers" for the data itself.
Then there will be a variable number of rows of funding sources for each employee. For example, I am paid partly by the Hospital, and partly by Pediatrics.
Then there will be some rows with totals which the accountants look at to make sure it all adds up.

I'm just after the funding sources rows. Looks like the easiest way is to create a cursor and append from the sheet. I can scan my cursor and there will be empties where text was appended into a numeric field. I'll just look for the rows I want.

Love to see your code. Mailto: cindyw@duke.edu

Thanks!


>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. ;-)