Error : Not a known format

[umairah]

I have a macro that read multiple text file and I got this error 

How can I make it become a known format, btw I use Flat file to read the file. 

Any guidance on this is really appreciated

Regards,

Umairah 

[Qiu · Accepted solution]

@umairah 
Chose CSV format and use \n as delimeter should get you going.