Unable to import data into a table using Import Wizard or Automation, if the date format in the import file doesn't match the database date format (223607)

Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Unable to import data into a table using Import Wizard or Automation, if the date format in the import file doesn't match the database date format
Description

Unable to import data into a table using Import Wizard or Automation, if the date format in the import file doesn't match the database date format
Cause

For example, the date format in the import csv file is dd/mm/yy and in the DB session is DD-MON-YYYY
Resolution

Go to the Automation task and Edit the import profile that was already setup. Then ensure you select the option 'Use Current Regional Settings' and save it. Then the import should work successfully.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Request or Create a KB Article »

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Unable to import data into a table using Import Wizard or Automation, if the date format in the import file doesn't match the database date format (223607)

Title

Description

Cause

Resolution

Leave a Comment