SubField() function

[Anonymous]

Hi,

This function just doesnt seem to work. I have tried loading the data with the lib path and disabling the standard mode.

Any help will be greatly appreciated!

-Thanks

[sunny_talwar]

I don't think this has to do with the SubField function because you are erroring out at the top of the table for ProductID... I think you will see the same error if you don't add SubField... it seems to be something related to the location of the file

[vvira1316]

Your file is missing ProductID field. Error is not for Subfield function. Please check

[Anonymous]

Thanks for your response.

But my access table does contain ProductID field!

I tried loading it again, but it doesnt seem to recognize the fields!

PFA

[Anonymous]

PFB!!

-Thanks,

[vvira1316]

Check spelling/case for the field. May be some typos

Probably path issue...

Is there a reason for doing it separately. Try putting it in the first load and comment out everything related to path to see if path is causing it to fail.

[Anonymous]

Any leads on this?