Thank you for send me the file. But unfortunatelly, I was able to import this file without problems - all date fields were OK. I reviewed dates and all look OK. I converted dates to "Text" and reviewed them, some records have different allignment, but that should not be a problem.
Next steps: 1. Please download updated scripts - now they include more error handling, so should give more information on what is wrong with data. 2. I also included the same script with old code - GetExcelSrcData_OleDB.ps1. So if you need to run your scripts you can do following: - Rename GetExcelSrcData.ps1 to GetExcelSrcData_Was.ps1 - Rename GetExcelSrcData_OldDB.ps1 to GetExcelSrcData.ps1
But please first test option 1 and post here more detail error message.
Option 1 - still the same error message, after updating the scripts. I had previously changed the transactions with dates 01-31-2014 to 01-30-2014, which is when the date inside the error changed to what it is still now.
As you did not get additional error information, it is possible that you did not updated to latest script. Can you please re-download the script and run again - I am expecting more information about an error. Likely because of server caching, you downloaded script, but it was still older version.
Comments
But unfortunatelly, I was able to import this file without problems - all date fields were OK.
I reviewed dates and all look OK. I converted dates to "Text" and reviewed them, some records have different allignment, but that should not be a problem.
Next steps:
1. Please download updated scripts - now they include more error handling, so should give more information on what is wrong with data.
2. I also included the same script with old code - GetExcelSrcData_OleDB.ps1. So if you need to run your scripts you can do following:
- Rename GetExcelSrcData.ps1 to GetExcelSrcData_Was.ps1
- Rename GetExcelSrcData_OldDB.ps1 to GetExcelSrcData.ps1
But please first test option 1 and post here more detail error message.
Option 1 - still the same error message, after updating the scripts.
I had previously changed the transactions with dates 01-31-2014 to 01-30-2014, which is when the date inside the error changed to what it is still now.