We were given a diskette with a csv file that we loaded into our database. the load seem to take an inordinate amount of time, so we 3 fingered it. Upon inspection, our database grew to over 400% of what it should have been. The data consisted of 2 fields: ItemCode text, qty int and there were about 1500 rows of data the load command was: Load Recd from a:order.dta as csv Examining the data on the diskette, the itemcode did not have quotes around it (the itemcode is all numeric anyways, it used to contain alpha but not anymore)
We eventually were able to import it by doing: Load Recd from order.dta without the "as csv" and it loaded in a few seconds. Can something be done about the load command to avoid this problem. If we hadn't stopped it, we probably would have run out of disk space. Bernie Lis
