| || |
I was under the assumption that a single sheet in an excel table is equal to a table name in access? For some reason when I try to query a field on TableA, I get the value no matter what Table name i put in.... even if the table/sheet does not have those field names o the sheet? Very confused...
Re: Excel tables?
It has been my experience that the table name needs to match the sheet name in the Excel workbook. Can you post an example of either your connect statement and/or select statement?