I need help to a SQL-query to an ACCESS-database

<i><b>Originally posted by : 4texx (4texx@tm1.at)</b></i><br />Hi, <br /><br />I want to make a SQL-query to an ACCESS-database!<br />I need data from two different tables. The first one is called "EL_TABELLE" and the second one "ET source"<br /><br />And I have problems with the "ET Source" table, because its name contains a space character.<br />I think thats the reason for this error message:<br /><br />Microsoft OLE DB Provider for ODBC Drivers-Fehler '80040e10' <br /><br />This error occurs only with Microsoft Access when one of the column names specified in a select statement does not exist in the table being queried. <br /><br />And there is no possibility for me to change the name of the table, because it's not my database<br /><br />If there is anybody who knows how to solve thise problem, please help me!!<br /><br />thanks a lot, 4texx<br />

<i><b>Originally posted by : aztec</b></i><br />Never do this or<br />put in between brackets when you call it<br />like so:<br /><br />[ET source]<br /><br /><br />------------<br />4texx at 7/14/2000 5:33:01 AM<br /><br />Hi, <br /><br />I want to make a SQL-query to an ACCESS-database!<br />I need data from two different tables. The first one is called "EL_TABELLE" and the second one "ET source"<br /><br />And I have problems with the "ET Source" table, because its name contains a space character.<br />I think thats the reason for this error message:<br /><br />Microsoft OLE DB Provider for ODBC Drivers-Fehler '80040e10' <br /><br />This error occurs only with Microsoft Access when one of the column names specified in a select statement does not exist in the table being queried. <br /><br />And there is no possibility for me to change the name of the table, because it's not my database<br /><br />If there is anybody who knows how to solve thise problem, please help me!!<br /><br />thanks a lot, 4texx<br />