Excel + ODBC

[adac4u]

Hi,
In ODBC Admin, I can create a new ODBC Data Source Name using Microsoft Driver for Excel file.

How can I build a query to select data out from Excel ?
what is a column names ? table name in Excel ?

Thanx

Adac

 

[ETID]

What app are you linking to this xls?

 

[Guest_imported]

I'm trying to do something similar (if not the same).

I'm writing an asp page that will pull information from an Excel spreadsheet, that has an assigned ODBC name. The range of data is called Courseware_Data. In this example-- [tt]request("incoming_database&quot[/tt] is set to the ODBC name of Courseware_Data_ODBC.

[tt]Set Conn = Server.CreateObject ("ADODB.Connection&quot
Conn.Open request("incoming_datasource&quot 'incoming database[/tt]

Then, I've got to write a SQL statement to pull info from here and add to the outgoing datasource.

I am stuck on how to refer to the "table" in the Excel spreadsheet. Will it be the same name as the ODBC (in my example: [tt]request("incoming_datasource&quot[/tt]) or will it be the name of the range of data (in my example: Courseware_Data)?

Thank you for your assistance!

PS: I think I just figured it out- it would be the range of data name? Please confirm!

-Steph

 

[Guest_imported]

I'm trying to and then i found this page:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q195951&

looks like the rigth answer to our problems.