I need to import a file, into Access, that gets downloaded from our main database everyday. The file is named "motor_accounts.asc". Will Access allow me to import this (.asc) file? I know I can do it manually but is it possible to import it using VB? I have used the TRANSFERTEXT methods in the past but I don't see and TRANSFERASC method. I would like to automate this importing process because it needs to be done everyday. I would rather push a button that imports the file instead of having to convert the file to a TXT file and then import it. Can anyone help?