Dear All,
I have a table (lets call it inputtbl) in which I have a field that contains entries like:
in record1: text1_text2_text3_text4
in record2: text1_text2_text3
etc
I have created an outputtbl where I have inserted 4 fields to insert the "_" separated values of the inputtbl
The problem is that I have difficulties with writing a code that splits the column of imputtbl to the columns in outputtbl
I tried Split in VBA but I did not succeed
Could you please help me?
Many thanks in advance
ps. I dont want to use Excel TextToColumn, this task needs to be carried out in Access in a way