Importing a xls file into Access - using windows API browser to select the xls file on the server - once selected the full path and filename is stored in a tbxPath.
Example: Z:\\051Share\Vacancy\Web Vacancy List as of 11-12-12
I want to capture the date from this string and append to the imported table.
Looking for code that will parse the string and return 11-12-12 as a date that could be appended to records in the table.
Example: Z:\\051Share\Vacancy\Web Vacancy List as of 11-12-12
I want to capture the date from this string and append to the imported table.
Looking for code that will parse the string and return 11-12-12 as a date that could be appended to records in the table.