Hi
I'm new to this forum and would like to get help and learn more from the experts.
Attached is the file that shows how I wrote the macro (highlighted in green) in access to extract the data from the excel (part of the file).
I put the excel to the access table and run the macro. However, I can't extract the required information.
eg I can extract 144A if they are all in Field3, but can't 012T8 if part of the data is in Field2.
Please advise how to change the macro so that the correct data is extracted as in column D
I'm new to this forum and would like to get help and learn more from the experts.
Attached is the file that shows how I wrote the macro (highlighted in green) in access to extract the data from the excel (part of the file).
I put the excel to the access table and run the macro. However, I can't extract the required information.
eg I can extract 144A if they are all in Field3, but can't 012T8 if part of the data is in Field2.
Please advise how to change the macro so that the correct data is extracted as in column D
