Fred, ODBC might work, but I have a feeling pulling data from Excel into R:base via ODBC will create an ongoing unnecessary headache.
I would just write a macro in Excel that will dump the data out of Excel into an ASCII fixed field file and then load the file into R:base. I would not use a delimited file because Microsoft has never seemed to be able to grasp the proper format for a delimited file. Now that I think about it, I think the latest verson of R:base for Windows can Load an Excel file directly. I am not a 100% sure about that. Take a look at the Syntex for the command LOAD on the R:base web site for the current documentation. Troy Sosamon ===== Original Message from [EMAIL PROTECTED] at 1/06/02 4:46 pm >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 ================================================ 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
