IMPORT TABLE "MENSUAL" FROM "NO_HEADERS.TXT" IN STORE IMPORT_BUG
(MEDOR , CIA , MOVIMIENTO , NUMRECIBO , PRIMATOTAL , COMISIONTOTAL ,
 COBRADOR , POLIZA , PRIMANETA , TOMADOR , PRODUCTO , FECHA_EFECTO ,
 CAPITULOCONTABLE , SUBAGENTE , COMISION , MATRICULA , FECHA_TERMINO ,
 INDICADOR_CDBC , MEDIADOR)
DELIMITER CHAR #9
QUOTE CHAR #255
DATE FORMAT 'dd/mm/yy'
DECIMAL CHAR ','

---

 Comments and Workarounds

---

The problem was primarily the lack of quotation characters around incoming string column data, but the secondary issue was that the tab character was being treated as whitespace, throwing off the import, causing the wrong data to be imported into the wrong column, and resulting in an error.

---

 Resolution

---

Fixed Problem on 4/3/2010 in version 2.03 build 10

---

 Products Affected

---

ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial