Hi there,
I usually extract data from a notepad (.txt) file with no problems. Recently, I have ran into an issue, where times after midnight are not loading/extracting into Excel. If I load the data as normal, those particular cells are blank and empty. When I tried again and looked further, I reviewed under "Transform Data", the cells in question say "Error", with the following message:
"Expression.Error: We couldn't parse the input provided as a Time value.
Details:
24:38:00"
This has never happened before, is there an added step I need or can do to fix this? So far, in my search, I've read something to do with spaces in the file, but I found none.
Thank you for your time and much appreciated if you can assist.
Bookmarks