The Excel file are like this:
Jan Feb Mar
Cost 1 2 3
Sales 3 5 6
....

The SQL tableA have colunms named cost, Sales,... and Month. It looks I have
to turn the table 90 degree.

Any one has good solution?

Thanks

"cowboy" <cowboy (AT) discussions (DOT) microsoft.com> wrote

help for some examples on how to handle it. SQL Analysis Services and MS
Access both have tools for this kind of table. Does the number of columns
increase each month, and what happens for the new year?
Jack Peacock

Only fond one example in BOL and I have no VB installed and can not use it.

Would mind give any further suggestion?

Thanks

"Jack Peacock" wrote:

"cowboy" <cowboy (AT) discussions (DOT) microsoft.com> wrote

have Access XP/2003 there are tools to manipulate pivot tables too. I think
your strategy might be to first import the table as is, then use an MDX to
extract the columns into rows, to unpivot into a final destination table.
Not an MDX expert tho, you might try a different newsgroup for that.
Jack Peacock

You can import the Excel file "as is" in an appropriate table, and then use
a "reverse crosstab" query to turn the table 90 degree.
Read this for a reverse crosstab sample
http://groups.google.it/groups?hl=it...3%26rnum%3 D7


"cowboy" <cowboy (AT) discussions (DOT) microsoft.com> wrote