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 > _____________________________________________________________________ >
