I had already tried
Let>SQL=select * from [sheet1$]

but I just tried it again and it works now


thank you

no that did not work so I named the range and used the range like this: Let>SQL=select * from [countries!country_names] but the still the same: the script runs without errors but confidently reports that there are zero rows and zero columns I have to say I am getting despondant. Let>connStr=Driver={...

Let>connStr=Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=%SCRIPT_DIR%\excel_Table.xls;DefaultDir=%SCRIPT_DIR% DBConnect>connStr,dbCountries Let>SQL=select * from [countries!A2:B3] DBQuery>dbCountries,SQL,tableCountries,numRecs,numFields The above code returns numRecs=0 and numFields=0 e...

I decided going straight to Access was a bridge to far. But, weirdly, I have the same problem with Excel as I do with Access. I have an excel table called excel_Table.xls Sheet1 contains: tag name ENG England FRA France (in cells A1 to B3) The macro below runs without errors but is adamant that Shee...

I am trying to use the DB functions with MS Access 2003 I have a table called countries in a database called test The table contains 2 records and 2 fields The following script runs without errors but insists that the table contains zero records and zero fields. Why? DBConnect>Provider=Microsoft.Jet...