epxort to excel removes trailing 0's

[Rommi Saar]

Hi!

The problem is that when exporting data to Excel thinks thant "0000123" is a
number. How to tell Excel that this field is text? Is there any way to call
the import wizard during exporting to Excel? That would let user select
which columns contain text. Inserting ' behind all fields is not good.

Thanks,

Rommi

 

[Tom Ogilvy]

you can put all the data in one column, then let the user do Data=>Text to
columns which will bring up the import wizard.

 

[Rommi Saar]

I'm currently using something like that:

ShellExecute(0,'open','excel',PChar('filename.txt"'),nil,SW_SHOWNORMAL);