Both Gateway and ODBC will (generally) work, but sometimes with some quirks and problems, probably more from the Excel end, than from the R:BASE end.
Sometimes I've had the best luck when I've exported the Excel data as an ASCII file and then loaded the ascii data into R:Base. (When you're in Excel use the SAVE AS command, select TEXT as your "Save As Type", and name the file anything you want.) Fred Antrobus 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 > > ------------------------------------------------------------------------ > Name: winmail.dat > winmail.dat Type: application/ms-tnef > Encoding: base64
begin:vcard n:Hirsh;Louis L. tel;fax:302-831-6905 tel;work:302-831-8125 x-mozilla-html:FALSE org:University of Delaware adr:;;116 Hullihen Hall;Newark;DE;19716; version:2.1 email;internet:[EMAIL PROTECTED] title:Senior Associate Director of Admissions and Chair, University Scholarship Committee fn:Louis L. Hirsh end:vcard
