using vb to write SQL(SELECT INTO) query

[smily]

I want to use the sql SELECT INTO query to select a particular row from my database then allocate only certain fields' data to variables.

dbs.execute "SELECT [NUM, TIME, DATE] into [num1, time1, date1] FROM TABLE1 Where NUM >5"

p.s.: dbs is a database

There is an error but I don't know where the error is...
can someone help me?

Thanks.

 

[LittleSmudge]

You shouldn't have the square brackets around the first block

dbs.execute "SELECT NUM, TIME, DATE into [num1, time1, date1] FROM TABLE1 Where NUM >5"


QED

G LS