Sure you can. Look into creating linked tables in Access (which is,
oddly enough, totally different from linking tables in Crystal). These
are aliases to tables in other locations (including Excel spreadsheets)
that can be used just like regular tables. I think that you'll find
that maintaining them in Access is a bit easier than working multiple
datasources in Crystal.
So, your join is going to be a bit tricky, because it's got an IF in
there. But, this should work (note that you will not
be able to
view it in the Query Builder in Access, and will only be able to see
SELECT TBL_HISTORY.*, Sheet1.*
ON Sheet1.[S Number] =
Obviously, you will need to add a WHERE clause, and you will probably want to actually specify the field in the SELECT clause. But, that should get you started.