How to upload decimal values

[guptasweb]

i am unable to upload data of decimal values in sql from excel file

[Gokul001 (Gokul Balaji)]

Hi @guptasweb

Have a look on the thread

How To insert Excel file data into MS SQL table

@rakeshadn Find the attached xaml file FYR Replace your connection string and file path. PFB SQL Table creation Query Create Table ExcelToTbl ( From_Currency NVarchar(100), To_Currency NVarchar(100), Conversion_Rate Decimal(10,5), Conversion_Date Date ) ExcelToTable.xaml (8.8 KB) Regards Madhura

Regards
Gokul

[Sudharsan_Ka]

HI @guptasweb

Do you get any error ?

Regards
Sudharsan

[guptasweb]

how to enter data in sql when entering the decimal values ,

[bzural]

Can I see your workflow where do you try to insert data?