Import Text file into MS Access 2007
Posted on 2014-11-27
I have a text file (.txt) which has thousands of lines with the following format:
each position represents customer_number;customer_name;project_name in the database respectively. Please note there is no field heading in the text file
MS Access 2007 database has a table name "customer" which has the fields as follows:
I should be grateful if someone could help me providing a VB script or a batch file to run an import of the data in the text file into MS Access 2007. Thank you.