How to pull data from EXCEL?
Posted: Mon Aug 02, 2004 1:14 pm
Can u give the value of "Tab" so that i can pull data when it is seperated by Tab Space.
And one more, i am trying to pull data from Excel sheet. Suppose the data is in the following format.
~~~~~ dealer1 dealer2 dealer3
month01 01d1 01d2 01d3
month02 02d1 NULL 02d3
month03 03d1 03d2 NULL
month04 04d1 04d2 04d3
month05 05d1 05d2 05d3
1.) Can u tell me how to pull the data of four columns from Excel sheet to Flat file or DB?
2.) The next task is --- from excel or seq, the data should arrange in the following order
month01 dealer1 01d1
month01 dealer2 01d2
month01 dealer3 01d3
month02 dealer1 02d1
month02 dealer2 NULL
month02 dealer3 02d3
month03 dealer1 03d1
month03 dealer2 03d2
month03 dealer3 NULL
and so on.....
I tried Pivot Stage, but i am not able to get column headers as columns (Dealer1, dealer2 and dealer3). Remember number of columns are not constant.
Hope you understand my questions.
with regards,
Cnu
And one more, i am trying to pull data from Excel sheet. Suppose the data is in the following format.
~~~~~ dealer1 dealer2 dealer3
month01 01d1 01d2 01d3
month02 02d1 NULL 02d3
month03 03d1 03d2 NULL
month04 04d1 04d2 04d3
month05 05d1 05d2 05d3
1.) Can u tell me how to pull the data of four columns from Excel sheet to Flat file or DB?
2.) The next task is --- from excel or seq, the data should arrange in the following order
month01 dealer1 01d1
month01 dealer2 01d2
month01 dealer3 01d3
month02 dealer1 02d1
month02 dealer2 NULL
month02 dealer3 02d3
month03 dealer1 03d1
month03 dealer2 03d2
month03 dealer3 NULL
and so on.....
I tried Pivot Stage, but i am not able to get column headers as columns (Dealer1, dealer2 and dealer3). Remember number of columns are not constant.
Hope you understand my questions.
with regards,
Cnu