>It seems like I've ran across this before but it complete slips my mind here. For fun I'm trying to import from some a CSV file into a vfp dbf.
>
>When I open up the CSV file in Excel, the Fields that have the memo field from my palm are in one column, but it appears that they have carriage returns and line feeds in them when I go into the cell, a huge pull-down drops down from the Excel formula bar showing the entire text of the memo field. I didn't know CSV files could do that! And I'm perplexed on how to convert it to a dbf. I tried saving it from excel to a dbf, that just truncated the "memo" text field, I also tried create a three column table with the first being of type MEMO and doing an append from type CSV. Neither of those techniques worked. I supposed I could use Automation with excel and grab the data that way, but isn't there an easier way to do this???
>
>Or better yet, is there a freeware/shareware tool out there that will allow direct import from a native Palm pilot .DAT file (memopad.dat, etc) directly into vfp? I've looked around and haven't found anything. I have so much stored in my palm device, and I can't stand how I can't do advanced searches from within the palm desktop software. I don't want to by Yet another pocket pc device and use windows CE compact framework with outlook, because I can't stand any of the latest Pocket pc devices as they seem pretty cheap quality and I am infuriated with battery life. My trusty palm IIIx works like a charm for 5 years now and it's the AAA batteries last forever between changing them. I just hate the lack of advanced searches (boolean, etc) that the palm os and palm desktop don't offer.
>
>The CSV file was created from my Palm Desktop (Palm pilot software). I only exported my Memos.

Rick,
You acan import by using lowlevel file processign or from excel get data using OLEDB.
Cetin