QUERY SYNTAX FOR CONVERSION???

[JRHEIN]

HELLO EVERYONE,
I'M HAVING A PROBLEM WITH A PROG. I WROTE IN VB. I'M CONVERTING INFO FROM ACCESS TO EXCEL IN VB AND AM HAVING ISSUES WITH SYNTAX FOR DATA EXTRACTION! THE PROGRAM WORKS AND ADDRESSES ALL DELIVERABLES. HOWEVER, NOW I NEED TO TAYLOR IT TO EXTRACT PARTICULAR RECORDS. HERE IS THE CODE:

Set conn = New ADODB.Connection
conn.ConnectionString = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & txtAccessFile.Text & ";" & _
"Persist Security Info=False"
conn.Open

Set rs = conn.Execute( _
"SELECT * FROM query1 ORDER BY loc_no", , _
adCmdText)

WHAT IS THE SYTAX TO SELECT * FROM [...PARAMETER] WHERE [...PARAMETER]....

PLEASE HELP!

IS ADMIN
JRHEIN

 

[RonRepp]

SELECT * FROM TableName Where OrderID="12345" (Use double quotes for Access, but only if it's a string. Integers, no quotes, dates start and end with # (#1/1/2007#)

I hope this helps.

Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.