Excel to SQL DB

[arjahan]

Hi Folks

I have one small problem, I want to run a query using <cfquery> to read excel
file data and then save them into SQL data base, its very easy you can preview
it in my attached code. but ...
My files have different sheet name and numeric column names so I have 2
problem:

1) When I run query for numeric coulmn query will return F1, F2 , F3 ....
instead of column name
2) I want to run a seperate query to get sheet name and column names first
(get excel sheet name and properties)

Any Idea?

Thank you
Al
Attach Code

<cfquery name="Test" datasource="excel">
SELECT TOP 50 * FROM IN '#excelFilePath#' 'EXCEL 8.0;'
</cfquery>

[LL@Work]

The table name is the sheet name with a $ sign at the end and surrounded by
brackets (i.e.
The column names are always the first row of the sheet
If you know the sheet name you can obtain the column names using the
#columnlist# sql variable
i.e.
<cfoutput query="Test">
#columnlist#
</cfoutput>

[arjahan]

I know I can get a column with column list but if you have column as numbers
like zip code then excel will return F2, F3 and ... plus each user will use
different sheet name so I need to find sheet name first from file properties.

please look at this sample
F2,F3,F4,F5,F6,F7,F8,... instead of 22180, 22182, ....