I'm pretty new to access and have some experience in VBA. So I need to manually import a text file, link it by creating a linked table, using advanced specs to separate everything, and later exporting the table to excel to a specific area in the sheet. The goal is to be able to do that automatically, the only thing I've found so far is to use: DoCmd.TransferText but as I said I'm new and I'm not sure how to go through all of this. Using Access 2016 so I added a macro and entered the specification name, table name, and file name but nothing happens when I run. Any help or alternate way of doing this??? Thank you in advance!