Adding Headers from another Database

  • Thread starter Thread starter miss_mas
  • Start date Start date
M

miss_mas

I am importing several text files that do not have headers, just data. I am
trying to append all of the imported tables to one another. The header names
are located in a separate file. I keep getting error message when trying to
use the append query because the files have generic headers .. F1, F2, etc.
How can I take the headers from the other table so I can append the files?

Help is greatly appreciated.
 
I am importing several text files that do not have headers, just data.  I am
trying to append all of the imported tables to one another.  The headernames
are located in a separate file.  I keep getting error message when trying to
use the append query because the files have generic headers .. F1, F2, etc.  
How can I take the headers from the other table so I can append the files?

Help is greatly appreciated.
Click to expand...

If they all have the same structure, why not just create an import
specification and reuse it in your import code? The rest of this
sounds like way too much work.
 
How do you do this? I see the place for it in the drop down on the Macro for
the TransferText, but there isn't anything there.
 
Back
Top