Hi,
I need to execute a query ...

datSQL.DatabaseName = txtPath.Text
sqlq = "SELECT ned_rpt_case_stats.* INTO temp " & _
" FROM ned_rpt_case_stats"
datSQL.RecordSource = sqlq

now this is the only way i know of ccessing databases in vb. please could you let me know how to actually dim something as a database and then use conn.execute so that my query will actually run.

thanks in advance