Query from text file and retrieve records using ADODB
Query from text file and retrieve records For example we have the following text file “Employees.txt” LastName,FirstName,Department,Role Nandvani,Rajiv,IT,Manager Kumar,PP,Finance,Analyst Shukla,Nikhil,R&D,Programmer Singh,ANIL,QA,Tester ARORA,ANUJ,QA,Team Leader Kumar,Neeraj,IS,Manager Is it important that your text files be formatted like this? It’s not just important, it’s crucial. We’re going to use database techniques to retrieve information from the file, and to do that the file needs to be delimited in some way (in this case, using the comma as the delimiter).