S
Sara
An ODBC linked table "A" needs to be replaced by a text
file "B", which will also be linked. However, "A" is an
Oracle table with column headings already in place. There
are about 150 columns. Even though "B" has the exact same
data, it does not have any column headings and they need
to be defined with the names in "A", so that it can
continue to work with the queries and macros.
Is there an easy way to copy the column headings from "A"
to "B", instead of typing 150 names which can cause
mistakes?
Thank you.
file "B", which will also be linked. However, "A" is an
Oracle table with column headings already in place. There
are about 150 columns. Even though "B" has the exact same
data, it does not have any column headings and they need
to be defined with the names in "A", so that it can
continue to work with the queries and macros.
Is there an easy way to copy the column headings from "A"
to "B", instead of typing 150 names which can cause
mistakes?
Thank you.