Column headers in text files

Hi,





I want to merge a tab-delimited text file with externally generated data into a database table, but the column headers are not recognized by the import wizard - they just show up as Field 1, Field 2 etc. Do the headers need a specific format in order to be recognized?





HomerE

Have you tried using the "First line is field names" option in the parser settings?


Click the ... button next to the selector for the file type after you have specified the file.





Tim

Hmmm...hidden feature. Not very obvious, but it did the trick. Thanks for your swift response.

Most file parsers have a number of options and there is not enough space for all of them in the main screen of the wizard, and many are not relevent much of the time, so we put them all into the options dialog that can be used where necessary.





Tim

HomerE wrote:

Hmmm...hidden feature. Not very obvious, but it did the trick. Thanks for your swift response.

Thanks for this comment. We were already planning to do some auto-detection whether the first row contains values or column names. It's typically possible when some column contains numbers in all rows except the first row. Of course this auto-detection can't work if file contains only text columns (so first row looks "similar" to all other rows). We will try to implement this feature in some patch release.