how to load date from excel file using teradata studio

Teradata Studio
Teradata Employee

how to load date from excel file using teradata studio

Hello,

I'm new to Teradata Studio. I try to load some Excel files to a table using the Data Transfer Wizard.

Unfortunately I got an error if I try to load dates.

What do I have to do, if I want o load dates from an Excel file to a date-column?

Do I have to specify a special format for the date-column in the table?

Or do I have to change the date-column in the Excel file?

Thanks in advance,

Torsten

Tags (1)
2 REPLIES
Teradata Employee

Re: how to load date from excel file using teradata studio

Teradata Date column format allows “yyyy-MM-dd", "MM/dd/yy", "MM/dd/yyyy” , and time format “HH:mm:ss.S", "HH:mm:ss” . Other formats may cause failure of the data loading or wrong date to get into the table. It doesn't matter of the file types. You can format the cell column in excel. Thank you.

Teradata Employee

Re: how to load date from excel file using teradata studio

Thanks!