To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78634
------- Additional comments from [EMAIL PROTECTED] Tue Jun 19 13:23:57 +0000 2007 ------- I must use a schema.ini otherwise only the first column is there. Please make sure, that all columns are there in OOo in the tables. You have to use table aliases which gives the engine a table name without fullstop. To use alias goto Edit > Database > Advanced Settings > Special Settings. Please have look at your field names. Are they in capitals? Then you must use capitals in the query too. For example the statement SELECT `Investments`.*, `MonthlyStatement`.* FROM `MonthlyStatement.csv` AS `MonthlyStatement`, `Investments.csv` AS `Investments` WHERE ( `MonthlyStatement`.`INVESTMENTID` = `Investments`.`INVESTMENTID` ) works for me. Using the SQL statement created by MS Query can only work as unparsed SQL, because it is the wrong syntax for OOo SQL interpreter. You can use delimiters as you like when saving from calc as csv. You have to check "Edit filter settings". All this things should be discussed in a forum or mailinglist before submitting an issue. A good place would be [EMAIL PROTECTED] --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
