Excel Number Database

Hello, for an automation i use an Excel to Database with Database activities.

I use à SQL request for recover information to Excel.

When I retrieve numbers and digits I have a little problem.

Select * From [Sheet1$] where ‘Description’ = ‘TEST LINE’
If have a space between number doesn’t works
Source :


Result :

Do you have a solution for this ? Thanks !

Resolve. I’m using LINQ request for replace.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.