I am looking for help in using the ImportExportSpecification properties (especially .path) to set the file path from a form text box through vba.
I have got the text box already showing the current database project file path.
All I want is to use this string to link up in the saved importexport paths.
I am importing and exporting access tables from one db to another and also exporting tables as excel files.
There seems to be mixed reaction to similar question on various other forums but no specific solution or example.