Excel to access

Question

Hi,

With respect to below macro. Which VB Reference setting I have to do for run this macro.

As I got error "Run-time error '-2147217900 (80040e14)': Syntax error in From clause. http://stackoverflow.com/questions/2764560/updating-ms-access-fields-through-ms-excel-cells

kindly guide.......

Answer 1

To use ADO stuff you have to add the below to your references:
Microsoft ActiveX Data Objects x.x Object Library

As for the syntax error, perhaps pasting some code and telling us which line the debugger says is erroring out on would help. My initial guess is some sort of select statement that is selecting something that doesn't exist -- but without code/intent/example data it would be hard to pinpoint.