Proper SQL Syntax - DAO
 

All -

I have reviewed the sample code at
http://www.bygsoftware.com/Excel/SQL/UsingSql.html
regarding the querying of an Access Database from Excel utilizing the DAO
library.

Below is the sample SELECT SQL Stmt from their web site:

vtSql = ""
vtSql = vtSql & " SELECT * "
vtSql = vtSql & " FROM " & ctSheet
vtSql = vtSql & " WHERE Namex Like 'R*'"

(ctSheet in the above example is Access Table Name).

QUESTIONS:
------------------
1. Instead of Field Name "Namex" I would like to query for Field Name
"Datex" greater than a particular date (say 01/01/2006). What is the proper
SQL syntax for such a request?

2. Is there something special about the field type your are requesting and
how you code the SQL string?

3. Is the WHERE SQL stmt on numeric field request different than the WHERE
SQL stmt on a date field request?

Thank you for your assistance.

MSweetG222

Proper SQL Syntax - DAO
 

Hello,

1. Datex = #01/01/2006#
(I am assuming you meant greater than or equal to)

2.
-strings are delimited with quotes, either single or double,
as long as they match
-dates are delimited with #
-numbers are not delimited

3. only that the dates are delimited and numbers aren't
(dates are actually stored as numbers, but they are written
differently)

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access



MSweetG222 wrote:
All -

I have reviewed the sample code at
http://www.bygsoftware.com/Excel/SQL/UsingSql.html
regarding the querying of an Access Database from Excel utilizing the DAO
library.

Below is the sample SELECT SQL Stmt from their web site:

vtSql = ""
vtSql = vtSql & " SELECT * "
vtSql = vtSql & " FROM " & ctSheet
vtSql = vtSql & " WHERE Namex Like 'R*'"

(ctSheet in the above example is Access Table Name).

QUESTIONS:
------------------
1. Instead of Field Name "Namex" I would like to query for Field Name
"Datex" greater than a particular date (say 01/01/2006). What is the proper
SQL syntax for such a request?

2. Is there something special about the field type your are requesting and
how you code the SQL string?

3. Is the WHERE SQL stmt on numeric field request different than the WHERE
SQL stmt on a date field request?

Thank you for your assistance.

MSweetG222

Proper SQL Syntax - DAO
 

Crystal,

Thank you so much.
I understand.

Thx
MSweetG222



"Crystal" wrote:

Hello,

1. Datex = #01/01/2006#
(I am assuming you meant greater than or equal to)

2.
-strings are delimited with quotes, either single or double,
as long as they match
-dates are delimited with #
-numbers are not delimited

3. only that the dates are delimited and numbers aren't
(dates are actually stored as numbers, but they are written
differently)

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access



MSweetG222 wrote:
All -

I have reviewed the sample code at
http://www.bygsoftware.com/Excel/SQL/UsingSql.html
regarding the querying of an Access Database from Excel utilizing the DAO
library.

Below is the sample SELECT SQL Stmt from their web site:

vtSql = ""
vtSql = vtSql & " SELECT * "
vtSql = vtSql & " FROM " & ctSheet
vtSql = vtSql & " WHERE Namex Like 'R*'"

(ctSheet in the above example is Access Table Name).

QUESTIONS:
------------------
1. Instead of Field Name "Namex" I would like to query for Field Name
"Datex" greater than a particular date (say 01/01/2006). What is the proper
SQL syntax for such a request?

2. Is there something special about the field type your are requesting and
how you code the SQL string?

3. Is the WHERE SQL stmt on numeric field request different than the WHERE
SQL stmt on a date field request?

Thank you for your assistance.

MSweetG222