In a previous post I used a VBA program that the forum helped me design that takes an Excel spreadsheet and allows one to select a column of numbers and then convert them to text values by adding a single quote ' in front of the number. It now converts it to a text value.
Now what I want to do is the opposite, but in Access. I want to change those converted values back to numeric from text.
I would also like to use the method (if I can) to just select the affected values in the Access cells and then invoke VBA code to convert them from text to numeric.
This program would be written in Access VBA.
My question is how do I do that?
Any help appreciated. Thanks in advance.
Respectfully,
Lou Reed