Import from CSV problem with Date Format

[Sainttdi]

Hi All!

I have big problem for importing a CSV file, to create a new table.

On the CSV, on the header row there are the column names, under i have the records (about 50'000, is there a limit?)

Importing the table, it imports all the columns with VARCHAR(255) type. But I have plenty of Date and time columns, the data stored like "25/09/2013 15:45:05"

On the Data Formats Tab, during the import, I have the "Auto detect date and time format" checked, but when the table is imported, the columns with Data and Time, has a VARCHAR type.

I tried also taking of the check on "Auto detect date and time format" and leaving the Date and Time: "dd/MM/yyyy HH:mm:ss" but it doesn't work.

Can someone help me? It's impossibile to change the type manually, beacaue there are too many "Date and Time" columns.

Thank you very much
Stefano

[alexa]

When importing data into a new table, a data type is not assigned automatically. You have to map it manually or import data into an already existing table.

The 'Autodetect Date and Time format' allows to automatically detect the format of the data selected to import to the Date or Time formats. If this option is unchecked, you can manually select the corresponding format.

(about 50'000, is there a limit?)

There is actually no known limit.