Create new table using another tables data as field headings
Hi
I need to create a new table, for the field headings I want to use the data in another table.
The only way I can think of is exporting to Excel, transposing, then importing back into Access, but I would prefer to keep it in Access.
Can this be done without using Excel?
Thanks in advance
Hi
I need to create a new table, for the field headings I want to use the data in another table.
The only way I can think of is exporting to Excel, transposing, then importing back into Access, but I would prefer to keep it in Access.
Can this be done without using Excel?
Thanks in advance
Last edited: