CODE EXAMPLE FOR CSHARP

C# oledb excel select column with space

//Columns: Commission Amount,Country ,Rep Name
Select [Commission Amount] , [Country ], [Rep Name] from [Sheet1$]
//You can use [] for escape char

//Columns: Comm Amount,Country ,Rep Name
Select [Comm# Amount] , [Country ], [Rep Name] from [Sheet1$]
//Also for .(dot) use # insted