Thanks Gary and Jan. I was considering that approach but wanted to get ideas before spending much time on this.
I appreciate this list and the help it has been since we switched over to 7.6 a few years back. The office people are getting spoiled and that is what I want. James Belisle ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Gary Wendike Sent: Monday, March 28, 2011 10:39 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: CHECK FOR VALUES I agree with Jan on using the temp table approach. I also load many files from xls, csv and access format a day and use a temp file to process, check and adjust the data before I ever load to the permanent table. I never load directly into my permanent table. Gary From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Monday, March 28, 2011 3:50 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: CHECK FOR VALUES Jim, I think you should import the XLS into a TEMP table to do your evaluations on. If the evaluations pass, APPEND to the permanent table. Jan -----Original Message----- From: "Jim Belisle" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Mon, 28 Mar 2011 15:25:44 -0500 Subject: [RBASE-L] - CHECK FOR VALUES Everyday we import into RBASE to files from EXCEL. One is a file with the time in and out for the whole day. (one per day per employee) The other has punches for specific work done for the day. (many punches per day) Certain employees, because their job is the same each day fail to punch in for the second file. What I want to do is check the excel file as it imports into RBASE for those employees and add a row with specific information. Any ideas as to the best way to accomplish this would be appreciated. James Belisle
