I'm not sure if i'm posting this in the right thread or not. It could fall under Macros, Forms or even here for VBA
This is what I want to do. But what I'm asking is are there any online tutorials/books/videos that would teach me the following:
I want to create a macro or VBA programming in Access 2016 where the user clicks on a button on a form that will walk them through selecting a fixed width text file for the purpose of importing the data in the text file to an existing table or creating a new table. The actions will also include checking for matching records so it will just update the existing records but will also add new records.
Again, I'm asking if there are resources anyone can point me to so I can learn how to do this.
Also, resources that will include using the 'Create, Macro' menu options to create the macro and using the action catalog, ImportExportText action
Thanks
This is what I want to do. But what I'm asking is are there any online tutorials/books/videos that would teach me the following:
I want to create a macro or VBA programming in Access 2016 where the user clicks on a button on a form that will walk them through selecting a fixed width text file for the purpose of importing the data in the text file to an existing table or creating a new table. The actions will also include checking for matching records so it will just update the existing records but will also add new records.
Again, I'm asking if there are resources anyone can point me to so I can learn how to do this.
Also, resources that will include using the 'Create, Macro' menu options to create the macro and using the action catalog, ImportExportText action
Thanks