MS SQL to MS Excel

[Ntra]

Hi,

The data migration from MS SQL to MS Excel is taking place without any error. But the problem occurred is that the field names are not displayed in MS Excel.

I am using MS Excel of version 2003 and Apatar version 1.12.23.

I have configured MS SQL(Data Source). With Transform operation I have connected to MS Excel. For MS Excel I have 15 fields, I have set offfset as 1 and firstFieldPosition as 1, FirstFieldName is checked. Is there any corrections in the configuration?

Please do reply.

-
Nethra

[Sergei]

Hi Nethra,

Most probably your filed names in MSSQL contains spaces between words. Try to add _ between words.
_________________
Regards,
Sergei