Loading data from the Cross/Pivot table
Let us say we have table like the following in the database:
| No | Field | Data Type |
|---|---|---|
| 1 | CUSTOMERID | CHAR |
| 2 | YEAR | DECIMAL |
| 3 | MONTH | DECIMAL |
| 4 | PRODUCTID | DECIMAL |
| 5 | AMOUNT | DECIMAL |
And a text files like the one below:
Year
CustomerID
ProductID
Month_1
Qty_1
…
Month_12
Qty_12
Click Data Source Button and check ‘Source file is a Pivot table’ check box and set First Field to 4, Blocks to 12 and Block length to 2
Finally we are ready to import data
Click 
to load data into the database