Hi,

I am right now working Excel using VBA. I am using DAO for reading an external sheet data. I am not getting the output. Can some one help me in fixing this problem. Following is the code snapshot:

Set rs = db.OpenRecordset("SELECT * from Instruction")
If rs Is Nothing Then
MsgBox "Can't open the file!", vbExclamation, ThisWorkbook.Name
db.Close
Set db = Nothing
Exit Sub
End If

Here 'rs' is returning null. I am trying to open a work sheet named 'Instruction' from an external workbook file. Could you please let me know the exact syntax for accessing the sheet information using DAO. And also how to refer column header in the 'SELECT' query if the column names have words separated by space. For example "Project Name" is the column header name separated by space. And any good DAO using VBA link will also help me.

Thanks in advance!

Ravo