ODBC Importer - Import Query Result

[bjt]

Can you please give me an example of a query with a "where" clause in the ODBC Importer "Import Query Result" section? Thanks.

 

[Theod]

Hi,

may be it depends on the ODBC-Source-Type.
For an Connection to an Oracle-Database
it's the same as in other sql-Windows.

First establish the connection.

select * from table_xyz
where col_abc = ....

Hit 'View data' to check the result.

 

[bjt]

Sorry, I didn't give you enough explanation... I'm importing from an Excel spreadsheet that contains two worksheets. It is set up as an ODBC Data Source called TICKET_517_OR_FUNCLASS. The two worksheets are called FUNCLASS=RESOURCE and FUNCLASS=LOCAL. What is the syntax to select specific records out of each of these worksheets?

Can you also tell me the syntax you would use for an Access Database?