header for csv ?

[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

 

[hgrove]

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.

...

Unfortunately, no.

 

[Dave Peterson]

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???).