![](https://cdn-0.access-excel.tips/wp-content/uploads/2014/12/feature_access_vba-e1503849948340.jpg)
This Access VBA tutorial explains how to import txt using DoCmd.TransferText Method in one Table or separate Table.
Microsoft Access - import TXT using DoCmd.TransferText Method
In my previous post , I explained how to use DoCmd.TransferText Method to export queries to files such as txt, this tutorial explains how to import txt into Table.
First prepare a TXT file such as below
Then import the txt file manually. Before the final step, create a specification (which field is what data ...
Read More