The current code that I got from another use is the following:
ConnectionString = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & SourceWorkbookPath & ";" & _
"Extended Properties='Excel 8.0;HDR=" & IIf(TablesHaveHeaders, "Yes", "No") & "'"
RecordSet.Source = SQLCommand
RecordSet.CursorType = adOpenKeyset
RecordSet.LockType = adLockOptimistic
RecordSet.Open ActiveConnection:=ConnectionString 'SQLCommand, ConnectionString ', 3, 3, 1 ' adOpenDynamic, adLockReadOnly, adCmdText
I think it definately needs tweaked as I'm also getting inconsistant errors about read only tables. At this point I need to get a better understanding of this or revert back to not even using ADO.