Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Karben Selim Mejia
  Where is Karben Selim Mejia?
 San Pedro Sula
 Honduras
 Karben Selim Mejia
 To: Whoosh Diaz
  Where is Whoosh Diaz?
 
 Guam
 Whoosh Diaz
 Tags
Subject: RE: Excel VFP7 data transfer Emergency -- PLEAS...
Thread ID: 33934 Message ID: 33981 # Views: 1 # Ratings: 0
Version: Visual FoxPro 7 Category: Microsoft Office Automation
Date: Friday, December 05, 2003 4:19:52 PM         
   


> Hi there,
>
> I have 2 problems that are quite similar to each other. I'd appreciate any help you can give.
>
> Basically these 2 problems work together as a check and match to balance accounting entries for my company.
>
> Problem 1.
>
> I have a worksheet with 6 columns that gets bigger daily as entries are added onto it. I need to capture all six columns, and append it to a database, but only lines that have the first column = date today. The format of the first column is MMDDYY (data type is "general").
>
> All other columns are also, of type "General", and my database (dbf) has numeric fields. Will the general data type populate my numeric fields?
>
>
> Problem 2
>
> I have another worksheet that is emailed to me daily. On this one, I need to capture the lines after the header "Account #". Similar to the first problem , I need to append each column into a field, and only stop, when the first column becomes empty.
>
>
>
> Any assistance will be greatly appreciated by yours truly. I am a newbie to VFP, so please assume that I know very little of it.
>
>
> Thanks,
>
> Kim
>
>
>
>
>
>
>
>
>

have you think about automation? is this an option? let me know and maybe we all can help you

Karben Selim Mejia

For _N=1974 to OnlyGodKnows

Honduras, Central America
The very centre of the world

ENTIRE THREAD

Excel VFP7 data transfer Emergency -- PLEASE HELP! Posted by Whoosh Diaz @ 12/5/2003 6:58:30 AM
RE: Excel VFP7 data transfer Emergency -- PLEAS... Posted by Karben Selim Mejia @ 12/5/2003 4:19:52 PM
RE: Excel VFP7 data transfer Emergency -- PLEAS... Posted by Albert itkin @ 12/5/2003 4:38:58 PM
RE: Excel VFP7 data transfer Emergency -- PLEAS... Posted by Whoosh Diaz @ 12/6/2003 2:02:41 AM
RE: Excel VFP7 data transfer Emergency -- PLEAS... Posted by Albert itkin @ 12/8/2003 5:57:06 PM