Microsoft Access - I would have a single column table created form a multiple record & field table.?

Question

I would like to have this table automatically created - I have a x Row by x Column (matrix) and want it converted to a single column table containing 'x' times 'x' records. (Actual table is presently 167 x 167, but would like to have query/SQL to be able to input actual size)

Answer 1

Try this:

Dim input() as String
Dim x as integer

>>use actual column and Table names in select<<

For x = 0 to Table1.COUNT
SELECT Column1, Column2, Column3 from Table1
input(x) = Column1, Column2, column3
NEXT

FOR x = 0 to Table1.COUNT
Update Table2
SET Column1 = input(x)
NEXT

good luck