I have attached three documents:
Employee Access DB
Employee Spreadsheet (linked into the DB as Employee Table)
Output.xlsx spreadsheet that gets output from the Employee Qry in the DB.
When I use the Like 12* to select records beginning with 12, the query works fine in the DB, but the records don't show up in the Output.xlsx spreadsheet. Not sure why. If I use In(123,124..Etc) the query works fine in Access and the records show up in the Output.xlsx spreadsheet. Why doesn't the "Like" expression work for the Output.xlsx spreadsheet? Thanks. - Tom