Recent content by sancarn

How do you give the SQL the query name 'qryTippingBucket'. In previous versions of SQL I have used 'into <queryName>' doesn't create a new table but creates a query named <queryName>. Sadly for me, that is not something I can do! It's good to hear that my syntax was alright though! :)...

Hi there, I'm new to the forums but I am not new to VBA or SQL. I'm a pretty advanced in VBA Excel and my SQL skills were honed in SQL Server 2003. However I'm stuck in a conundrum which I cannot solve. The problem: The problem itself is embarrassingly simple. I want to: Use...