Been working on this all day (Excel 2002). I want to create the proper "links" to have a MS Query read an EXISTING .xls (by going to Import External Data as a START), then return the selected rows via the MS Query Criteria to a 2nd .xls. I actually had a similar MS Query like this working (I got LUCKY), but I cannot remember how/what I need to create the "links" - that is very confusing regarding WHAT I need to choose as a "data source", AND then where to go next from THERE, IF I need .odc and/or .dsn, etc. - Just DAMN confusing, for sure. Can't find any answers on the web.
Bookmarks