Hi Fred Beware, I reluctantly take data in from excel, big problem is if someone slips an extra column in, justifies the data in a column or used dittos. Looks fine in a spread sheet but plays havoc with data loading. Gateway works fine provided you can trust the spreadsheet layout. Ian
At 15:46 06/01/2002 -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 > > ================================================ 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
