Question
Thread display: Collapse - |
All Answers
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Importing Text from Excell to Access.
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.