Fred- You might want to look at the "Attach dBase file" feature in RBase. Just save the Excel sheet as a dbf file and then you work with it directly in RBase. The dbf table can be accessed directly by Rbase commands (with some limitations). If you have a multi sheet Excel file, then each sheet can be save as a different dbf file. See what you think. You can automate or semi-automate the entire process.
Dennis ***** At 03:46 PM 1/6/02 -0800, you wrote: >I am about to work on a new project > >A office uses excel to keep track of each employees time > >I want to be able to take these spreadsheet forms once a month and import >the data into the >R:Base billing system that they have been using for years. > >There will be 15-30 sheets every months sent via email to the time and >billing person >Because of training issues (something about old dogs and new tricks...) >I do not want to make a R:Base entry form for the end user. > >I was looking for suggestions on the best approach > >The two obvious ones are: >1. Do a gateway import into a temp table >2. ODBC connection selecting data into a temp table > >Any suggestion or comments are welcome. > >Thanks, >Fred Antrobus >[EMAIL PROTECTED] >(425) 235-7796 > > > >Attachment Converted: "C:\INET32\download\winmail1.dat" > Dennis Fleming IISCO http://www.TheBestCMMS.com ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l
