|
Size: 654
Comment:
|
Size: 687
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| = OFFICE CHOICE DATA IMPORT = | |
| Line 3: | Line 4: |
| Stock import: |
== Stock import: == |
| Line 9: | Line 9: |
OFFICE CHOICE DATA IMPORT
Their data is in some sql flat file database and comes with dos apps to extract it with.
Stock import:
To generate the data use this command:
sql.exe "select code,sup_code,c_code,name,per,sg_code,n_cost,on_h,lpo_date,lm_date,lr_date,price from stock;" > stock.txt
Inside stock.txt is hopefully data for all those fields in fixed with format. However since this data and programs are from 1991 the dates are all fubared and so stuff for say 26th july 2006 will come out in teh format, 07/26/106, this also frells with the fixed with output so you need to manually adjust the headings to make them align before trying to open it with excel.