Openrowset operator does not display decimals in some columns

Viewed 17

I have the query:

select *
        from 
        openrowset ('msdasql', 'driver={microsoft text driver (*.txt; *.csv)}; 
                  defaultdir=f:\Temp\Presupuesto\Formatos Gasto\;' 
                  ,'select * from menores.csv')
        where cuenta <> ''

this query shows me columns with decimals and columns without decimals.

In the Menores.CSV is displayed this way:

enter image description here

When I run the query it shows me this:

enter image description here

0 Answers
Related