PDA

View Full Version : [SOLVED] Importing data from a MySQL database



Romulo Avila
04-07-2019, 05:58 AM
Good Morning,
I need a help, I have a routine that searches the data on a MySQL database, the routine is bringing the data but I have 03 columns that are values ​​and when it is imported into EXCEL this is brought as text, what can I do to solve it.


** the columns that I need to return in values ​​are highlighted in the image24015


Thank you

Bob Phillips
04-07-2019, 10:21 AM
Does casting it work?


Activesheet.Range("D" & I).Value = CInt(gRs!Valor)

or

Activesheet.Range("D" & I).Value = CDbl(gRs!Valor)