ODBC error to Access to DB2
I want to use Excel to retrieve orders and inventory information from a DB2 database. I have set up an Access file with 16 queries to get the data in the format that we need in Excel. The first 4 Access queries are pass-through queries that get live data from DB2. The queries run fine from Access, but when I run the final query from Excel (Data - Import External Data - New database query), I get an error that says
Reserved error (|); there is no message for this error
The strange thing is that I can run queries 8 thru 15 with no problem. The first 7 queries give the same error message. I saw somewhere that this could have with long filenames, so I shortened the Access filename, but it didn't do anything
Any suggestions??
|