Convert SQL to Microsoft Query

		Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Convert SQL to Microsoft Query

Excel VBA Discuss using VBA for Excel programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

April 18th, 2008, 01:49 PM

tgates

Registered User

Join Date: Apr 2008

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

Convert SQL to Microsoft Query

I have this current code written in SQL.

where jobname = 'ICE_GAS_DA'
and delivdate = dateadd(day, 0, convert(datetime, convert(varchar(10), getdate(), 101)))

MS Query does not recognize this and will not display the data. Anyone know of a similar MS query? I also would not mind if you have an MS query that will pull a date from a cell entered manually.

Anything would help. Thanks.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SQL Query to Convert Columns into Rows	Niaz	Oracle	3	February 5th, 2010 07:08 AM
SQL Query to convert Columns into Rows....again	phix	SQL Server 2000	11	November 11th, 2007 09:59 AM
I am trying to convert a MS Access Query to a SQL?	WebLadyBug	SQL Server ASP	3	March 9th, 2007 12:39 PM
SQL Query to Convert Columns into Rows	Niaz	SQL Server 2000	2	April 20th, 2004 01:36 AM
Convert String Date to Date for a SQL Query	tdaustin	Classic ASP Basics	4	July 7th, 2003 06:01 PM