Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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 (4236877)
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.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Recommended Content
Product(s):
Toad Data Point
Topic(s):
Troubleshooting
Article History:
Created on: 1/3/2017 Last Update on: 5/7/2023
Thank you for your feedback for Topic Request
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
Search All Articles
IE 8, 9, & 10 No longer supported
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.
