epxort to excel removes trailing 0's
 

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

epxort to excel removes trailing 0's
 

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.

--
Regards,
Tom Ogilvy


"Rommi Saar" wrote in message
...
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

epxort to excel removes trailing 0's
 

I'm currently using something like that:

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

"Rommi Saar" wrote in message
...
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