How TO: Import Data into an Access Database

From: Tony (lasallsoft_at_aol.com)
Date: 05/29/04 

Date: Fri, 28 May 2004 18:31:01 -0700

'Import by using OPENROWSET and SELECT query.
    strSQL = "SELECT * INTO tblCustomers FROM " & _
        "OPENROWSET('Microsoft.Jet.OLEDB.4.0', " & _
        "'Excel 8.0;Database=D:\testlib\xltest.xls', " & _
        "'SELECT * FROM [sheet1$]')"

Syntax error in from clause

Tony