java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Extra ) in query expression 'B.BNUMBER=T.BUY_BILL) AS BUY_DATE, BUY_PRICE, BUY_VENDOR, SELL_BILL,(SELECT B.BDATE FROM BILLS AS B WHERE B.BNUMBER=T.SELL_BILL) AS SELL_DATE, SELL_PRICE, SELL_VENDOR FROM TRADES T'.
but the same query runs fine in MS access....when run independently of java....
I am using MS Access as the Databse [ November 27, 2006: Message edited by: Bear Bibeault ]
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com