Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Power Query import text file from folder error

0

Hi,

Iam trying to import text file from folder in power query . My text file is having 4000 rows when i try to combine & load through custom separator | it's showing error as "value duration was either too large or too small for timespan"

Can anybody sugggest how to resolve this issue please.

excel
MS Office Version: 2016
posted by: Anil Kumar on Mon Mar 22, 2021 at 1:29 pm
Answer
Discuss

Discussion

Hi Anil and welcome to the Forum.

I have no experience of this error (and searches don't produce anything helpful). Does the error occur if you try the same power query on a smaller data set (say 100 records) or with a different custom separator?
John_Ru (rep: 6142) Mar 23, '21 at 6:11 am
Tq John.

Yes john i tried with 100 Rows Data but still its showing same error. I have attached screen shot below. Can you please check and get me out of this.
Anil Kumar Mar 31, '21 at 11:31 am
Anil

Thanks for the reply but you can't acttach screenshots (only Excel files are allowed, added to Questions and Answers).

Sorry but I can't help you.
John_Ru (rep: 6142) Apr 1, '21 at 2:06 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login