|
hsedidin
Starting Member
5 Posts |
 Posted - 2001-11-20 : 08:22:50
|
| I am having a problem with importing a csv ( a few rows are shown below) using dts into a table from which I need to update another table. The problem is that I need to add the stock from all the whse into one field with the isbn as the key. The stock and price will update where the isbn exists. The csv has over 1,300,000 rows. Any suggestions would be appreciated.Howardisbn,whse,stock,backorder,disCode,price0001025252,SOM,1,0,H,9.950001046403,MOM,0,3,H,14.950001047647,MOM,2,0,H,14.950001047647,SOM,3,0,H,14.950001047655,MOM,3,0,H,14.950001047868,MOM,4,0,H,14.950001047868,REN,3,0,H,14.950001047868,SOM,3,0,H,14.950001047973,SOM,1,0,H,14.950001048074,MOM,1,0,H,22.950001048503,SOM,2,0,H,14.950001049143,COM,3,0,H,11.950001049143,MOM,1,5,H,11.950001049143,REN,5,0,H,11.950001049143,SOM,4,0,H,11.950001049283,REN,1,0,H,14.950001049356,COM,1,0,H,14.950001049356,SOM,6,0,H,14.950001049690,MOM,0,1,H,14.950001049690,REN,1,0,H,14.950001050184,REN,1,0,H,14.950001050184,SOM,0,3,H,14.950001050192,MOM,3,0,H,14.950001050494,MOM,1,0,H,14.950001050494,REN,0,1,H,14.950001052012,COM,0,1,H,14.950001052012,SOM,0,1,H,14.95 |
|
import csv problem