I am attempting to search a database by partnumber by using a join of a batch entered file of partnumbers. The test code is below. I don't have any problem with the connection as I can see both the SQL in a recordset and the text file values with Dreamweaver recordsets. I don't have a problem if the join is two tables in a single connection. The problem seems to be how to connection and define two different connections. It seems to be the way I am setting up the connections either through a command or conneciton object or my approach.
There seems to be a method of using the IN to specify known types for external reference like dbase IV type etc. However a suggested method was to use the Microsoft Text File driver to connect to the text which works in isolation. It just seems I can't get the syntax write for two different connections in the same SELECT.