$$Excel-Macros$$ Re: Join Sql statement in VB using ADODB

2012-06-23 Thread TJ
Thanks much I went ahead a copied that into the Editor and it looks like it added a few quotes and arranged some things automatically. Assume some sort of autocorrect mechanism. Ran it and it threw a "Run Time error '424': Object Required" on the "VV_VESSEL_VISIT.VESSEL_ID , VV_VESSEL_VIS

Re: $$Excel-Macros$$ Re: Join Sql statement in VB using ADODB

2012-06-23 Thread David Grugeon
I thought SQL required all statements to end in a semicolon ?? On Sunday, 24 June 2012, TJ wrote: > Thanks much > > I went ahead a copied that into the Editor and it looks like it added a > few quotes and arranged some things automatically. Assume some sort of > autocorrect mechanism. Ran it an

Re: $$Excel-Macros$$ Re: Join Sql statement in VB using ADODB

2012-06-24 Thread Sam Mathai Chacko
Not necessarily! Regards, Sam On Sun, Jun 24, 2012 at 8:40 AM, David Grugeon wrote: > I thought SQL required all statements to end in a semicolon ?? > > > On Sunday, 24 June 2012, TJ wrote: > >> Thanks much >> >> I went ahead a copied that into the Editor and it looks like it added a >> few quo