Rotate data in Access2000
I have a CSV file which has 10 rows and 3 columns.
How do I import this data into an Access2000 table so that the rows become the columns and the columns become the rows?
Software
I have a CSV file which has 10 rows and 3 columns.
How do I import this data into an Access2000 table so that the rows become the columns and the columns become the rows?
by misscrf
Import the data into a table and make a pivot table. You can do this in excel or access. You will have to play with it to get the row data into the column data as you want it.
good luck.
by dliby
Pivot tables do not work on this issue
by dliby
by dliby
This discussion is closed to new replies.
Sort by Trending