I think this has something to do with the [EXCEL 5.0;]
portion of my string
as folows:

strSQL = "SELECT [SYMBOLS$].* INTO [SYMBOLS_ALL] FROM
[SYMBOLS$] IN '" &
strFullName & "'[EXCEL 5.0;];"


I prefer Jet's 'brackets' syntax to the IN syntax you are
trying to use. With an alias for the Excel worksheet
(table), try something like this:

SELECT XL.*
INTO SYMBOLS_ALL
FROM [Excel 5.0;Database=C:\MyFolder\MyWorkbook.xls;].
[SYMBOLS$] AS XL;

BTW Excel 5.0 is for Excel95 (and some below) format. For
Excel97 and above formats, use Excel 8.0 in your
connection string.

Also, as you are using ADO, ensure your source workbook
(strFullName) is not an open workbook, otherwise you'll
fall foul of the dreaded ADO memory leak bug (or something
very much like it).

Jamie.

--