Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  creating a table from another tables column titles

Author  Topic  nevyn Starting Member 2 Posts Posted - 2001-05-15 : 07:10:49 Hi :) I need to extract the names/titles of all the columns in table A and place them in table B. eg, table A has three columns called 067543, 456783, 4567883 (auto generated you see). Table B has one column, Titles, and should end up with three rows, 067543, 456783, 4567883. As for number of columns to deal with etc. I am processing tables with up to 800 columns. Column titles can be numbers, text or anything Access will allow. Thanks in advance !