Excel to Access

[Latin Seminary]

Hi,
How can we transform Range of cells from excell to access table?
i.e.
name number1 number2 number3 ....
John 50 60 55
Debra 60 55 70
....

Khalil

 

[Debra Dalgleish]

To reorganize the data, you can use the "unpivot' technique described by
John Walkenbach:

http://j-walk.com/ss/excel/usertips/tip068.htm