Use a different delimiter in the file than comma. A ~ or ^ could work well.
David Blocker ----- Original Message ----- From: "mike illich" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 9:42 AM Subject: [RBASE-L] - Re: create a dbf file from a Rbase 4.5 table > unload as ascii woked ok. > trouble is, that the client uses a lot of commas in his data, so a comma > delimited column into MS Access does not work too well. i found that one > column causes the problem in gateway. exporting with all the other columns > works ok. any ideas? > thanks much, so far. > > ----- Original Message ----- > From: "van der Zwaag, Frank" <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > Sent: Wednesday, October 15, 2003 7:23 PM > Subject: [RBASE-L] - Re: create a dbf file from a Rbase 4.5 table > > > > Wouldn't using the 'unload as ascii' command a good alternative? I do a > lot > > of loading / unloading and it works like a breeze. > > > > frank > > > > > > -----Original Message----- > > From: MikeB [mailto:[EMAIL PROTECTED] > > Sent: Thursday, 16 October 2003 12:38 > > To: [EMAIL PROTECTED] > > Subject: [RBASE-L] - Re: create a dbf file from a Rbase 4.5 table > > > > > > Have you tried it without the Sort. Just select the columns and the name > > of the file to receive > > the data and export all rows. > > > > ----- Original Message ----- > > From: "mike illich" <[EMAIL PROTECTED]> > > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > > Sent: Wednesday, October 15, 2003 5:46 PM > > Subject: [RBASE-L] - Re: create a dbf file from a Rbase 4.5 table > > > > > > > in Gateway, I am selecting all the columns of a table and sorting and > when > > i > > > hit f2 to do the export, it says > > > "verifying query " > > > "error Syntax error Press any key to continue" > > > ----- Original Message ----- > > > From: "MikeB" <[EMAIL PROTECTED]> > > > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > > > Sent: Wednesday, October 15, 2003 10:37 AM > > > Subject: [RBASE-L] - Re: create a dbf file from a Rbase 4.5 table > > > > > > > > > > I have that info, but the routine was limited to 6 column dbf file. I > > > just did an export to DBF > > > > with 4.5 and had no problems. What problem are you having? 4.5 is > > > notoriously stable and had no > > > > exports quirks that were showstoppers to my knowledge. > > > > > > > > ----- Original Message ----- > > > > From: "mike illich" <[EMAIL PROTECTED]> > > > > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > > > > Sent: Wednesday, October 15, 2003 10:12 AM > > > > Subject: [RBASE-L] - create a dbf file from a Rbase 4.5 table > > > > > > > > > > > > > I'm trying to convert a Rbase 4.5 file to another format via an > ASCII > > > file > > > > > or dbase file. I'm having trouble with the gateway program, it > gives > > me > > > > > "error syntax error" every time I try to export the data to ASCII or > > > dbase > > > > > (dbf). > > > > > > > > > > I recall from about 10 years ago, a routine (cmd file) which would > > > create a > > > > > dbf file from a Rbase table. I probably have that write-up > somewhere > > in > > > my > > > > > archives, but if someone has it handy, I would appreciate having it. > > > > > Thank you. > > > > > Mike Illich > > > > > > > > > > > > > > > > > > > > > > > > ____________________________________________________________________ > > CAUTION - This message may contain privileged and confidential > > information intended only for the use of the addressee named above. > > If you are not the intended recipient of this message you are hereby > > notified that any use, dissemination, distribution or reproduction > > of this message is prohibited. If you have received this message in > > error please notify Air New Zealand immediately. Any views expressed > > in this message are those of the individual sender and may not > > necessarily reflect the views of Air New Zealand. > > _____________________________________________________________________ > > For more information on the Air New Zealand Group, visit us online > > at http://www.airnewzealand.com > > _____________________________________________________________________ > > > >
