Is it possible to import text containing brackets () from Excel into Access. I have no problem with the pull when I pull the data into Access and display it on a lable, but when I write it to a Record Set I get a conversion error even though the underlying table has a text field in place.
Because the Excel Files Im working with are not really DBase Friendly, I have to loop through a range of cells with this code for each separate pull
vTest = wb.Worksheets(“wrkIPTV IRDsetting”).Cells(R, C).Text
I’ve dimmed vTest as a Varient and as a String, neither helps the problem when writing to the rs.
Let strCap = CStr(vTest)
Let DRS.Fields(C).Value = strCap
The code workes fine for the first 5 columns, but chokes on the 6th with the ().
Your help much appriciate. BB.