Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Whoosh Diaz
  Where is Whoosh Diaz?
 
 Guam
 Whoosh Diaz
 Tags
Subject: Excel VFP7 data transfer Emergency -- PLEASE HELP!
Thread ID: 33934 Message ID: 33934 # Views: 2 # Ratings: 0
Version: Visual FoxPro 7 Category: Microsoft Office Automation
Date: Friday, December 05, 2003 6:58:30 AM         
   


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











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