header for csv ?

  • Thread starter Thread starter Ralf Meuser
  • Start date Start date
R

Ralf Meuser

Hi there


I would like to know if there exist a header for csv file, which will tell
for example that the first column has un datatype of date, the second text
and so on.

Because I create a textfile with seperators, and each time I import this
file I have to go through each import step.


Thanks in advance


Ralf
 
Ralf Meuser wrote...
I would like to know if there exist a header for csv file, which will
tell for example that the first column has un datatype of date,
the second text and so on.
Click to expand...
...

Unfortunately, no.
 
If your file is always laid out the same way, you could record a macro when you
do it once and then use that macro to import subsequent files.

But excel doesn't like to follow your code when opening .csv files. You'll have
to rename them, too (.txt???).
 
Back
Top