Pyodbc Import Error Because Of Invalid Datetime Format
I´ve already look it up here, but couldn´t find a solution for my problem. I want to get a dataframe from 4 accces databanks and 2 work with this exact code and the other 2 displ
Solution 1:
So I finally find the answer. I selected the Error showing column and import it as a string. I just wrote:
df = pd.read_sql_query(sql='SELECT ID, ..., Cstr(dtime), dates FROM TB_cycles_car', con=conn)
The DataError didn´t show up anymore :) Thanks a lot @GordThompson for helping!
Post a Comment for "Pyodbc Import Error Because Of Invalid Datetime Format"