Tom Create a temporary table with columnames that are not in your database that way you can define them all as text. Use the function SKEEP or SKEEPI on each of your columns in question. Then unload the data from your temporary table to a file then load the file into your permanent table.
Buddy From: [email protected] [mailto:[email protected]] On Behalf Of Thomas Eldred Sent: Thursday, June 25, 2009 8:29 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Import issue Good Morning, I am seeking some assistance with importing some data back into RBase. I sent a CSV file to be CASS/DPAVE/POSTNET encoded by a mail house. Thank RBase for its wonderful export abilities. The file returns to me but I am having issues returning it to RBase. The file came as XLS with some added mail sorting codes. The issue is that one of the fields should be my numeric postnet barcode information. If I import the data with this field as a text value, it works....but if imported or converted to integer it fails. At times....opening the file with other programs (Excel, QuatroPro, notepad) There appear to be double pipes at the end of the values...but only sometimes and twice they have imported into RBase. These pipes are not visible and do not show up all the time. Would using double solve the issue? And would double still allow me to generate the postnet barcodes? Thank you for any thoughts or suggestions you may be able to provide. Tom Eldred
