> I'm having some problems using an ODBC connection to a an Excel
> spreadsheet. The main thing I haven't gotten to work is the naming of
> tables. I read a prior post saying to list the field names along the
> top row, but where does the table name come from? If anyone could send
> me a sample Excel file that is properly formatted as a database, I'd
> greatly appreciate it. Thanks.
The table name is odd, but quite usable once understood:
If the page name in the workbook is "MyData", then the SQL table name is
[MyData$]
so;
select * from [MyData$]
will read all of the rows
The first row is always read as the column names
I believe (only tested once) that the table name can be a named range,
specified as above.
HTH
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
