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.
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.