Wise Owl Answers - How do I import tab delimited files with ActiveX Data Objects?

[@janezklun]

Hi Andrew, the best vba there is on YT, thank you for nice explanation of complex topic.

[@WiseOwlTutorials]

You're very welcome Janez, thanks as always for watching and for commenting!

[@idogus]

The information you provide is very valuable.

[@WiseOwlTutorials]

Thanks Ibrahim!

[@imranbhatti8580]

As expected, really informative content once again.

[@WiseOwlTutorials]

Thanks for watching!

[@Scooter7788]

Thanks Andrew, your videos are so beautiful

[@WiseOwlTutorials]

Ahh thanks! Happy to hear you like them, thanks so much for watching!

[@shawn0902]

Thanks Andrew👍

[@WiseOwlTutorials]

You're welcome! Thanks for watching!

[@big1975E]

Great video! How would the code change if your file was saved to One Drive and the workbook path was an https address?

[@krn14242]

Thanks Andrew..

[@WiseOwlTutorials]

You're welcome Kevin, thanks for watching!

[@tejamarneni]

Thank you Andrew for an amazing video. Hope to see more videos from you.

[@WiseOwlTutorials]

You're very welcome, thanks as always for watching!

[@online7198]

Hello Sir, I am very happy to follow your videos, and I would like to ask you a question: How do I access the data source on a site that have searching box using VBA Selenium?

[@dilipdelwash3192]

Hello sir, I am getting this Error, Please Tell me how to solve this error
"[MicroSoft][ODBC Drive Manager] Data soure name not found and no default driver specified"
Thanks.............

[@Matt-zp9jg]

Hey not sure if you found your solution, but I had the same issue. The problem is the connection string you are using. If you have a 64 bit, you have to use connection string "Driver=Microsoft Access Text (*.txt,*.csv);Dbq=c:\txt\; Extentions=asc,csv,tab,txt;". Hope this helps having the same issue.

[@prasathv6258]

Please upload power query tutorials...

[@ousmanetall1286]

Can we add criteria in sql with this type of files?

[@WiseOwlTutorials]

Hi! Yes, you can add a WHERE clause to the SELECT statement which you use to set the Source of the Recordset object.