Connection

[smilingjohn]

Hi Expertise

,

   From the OLEDB im trying to get this below table as shown in the screenshot .

   And converting the Impact_ID into text

   Is this the right way of pulling ?

If you look at line 12 there is    SQL SELECT * FROM " Customer_Dell".Payroll;

Is it  correct ?

JUst confused with this

   Please do suggest .

   Thanks in advance

[Anil_Babu_Samineni]

Yes, till we are in good. So, what does text() uses in your script?

[avinashelite]

what the purpose of converting it to text ? whether it to get the numbers correct ? then I would suggest to convert the Impact_ID to text in the SQL level that is the ideal way to do

[smilingjohn]

Hi Avinash .

Becuase Impact_Id as bt numbers and text ...therefore i have to convert this into text..

Becuase one more table which is coming from EXCEL has text format too.

Therefore i have to forcefully convert this to text becuase if i dont do this then iam not getting below numbers

9.10. 11.10,15.10

instead it is consodering the above numbers as

9.1,11.1, 15.1 and so on ..

[smilingjohn]

Hi Anil.

Text is the alphanumeric combination in the Impact id..

my doubt was like if i use SQL Select * from ...should not make any missmatch as shown in the fscreenshot

T

Thanks

[avinashelite]

the above syntax looks good not issue you could go ahead

[Anil_Babu_Samineni · Accepted solution]

True, It won't. Will move ahead..