You can try setting up an odbc connection to the excel file. Dan
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ben Petersen Sent: Monday, February 04, 2002 11:09 PM To: [EMAIL PROTECTED] Subject: Re: Issue with GATEWAY in RBW 6.5++ J.M. -- You should be able to define a text field to 1500 chars, but that probably won't help. Have you tried just saving the Excel file as a delimited file and just "load" it to RBase? Ben Petersen On 5 Feb 2002, at 9:22, J.M. GRATIAS wrote: > > Hi all, > > > I use RBW 6.5++ (1.842xRT03) and I try to import a file from EXCELL 97 into > a table that contains a NOTE column. > > If I use XLS4 format, it works, but NOTE field is truncated at 255 char. > > If I use ASCII TAB delimited format, it works, but NOTE field is truncated > at 511 char. > > In both case, the file output from EXCELL is correct (not truncated) : > truncation occurs during the import process in RBW. > > I use the GATEWAY dialog box. > > Same happen if the NOTE field is changed to TEXT (1024). > > Question : Is there a way to import full NOTE field (max length is no more > than 1024 char.). > > TIA, > > > J.M. GRATIAS, Logimatique, France > ================================================ > 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 > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.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 ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.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 ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
