steps are as below:
1. In cf administration odbc option : select microsoft Excel
driver(*.xls )driver
2.add datasource name
3. select workbook proper version and create it.
While using this datasource it creates the tables same as the sheet name. In
the sheet if 1st row contains any data that is considered as column name.
(req. don't give anything in 1st row then by default it takes f1,f2... as
column names. this is easy to access. If column name are given in 1st row
then it should not contain any space in name i.e required.Same as SQL
requirement)
Hope this solves your problem.
----- Original Message -----
From: David E. Crawford <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Tuesday, March 28, 2000 6:54 PM
Subject: Excel Workbook/Worksheet as Datasource
> I realize this may have already been discussed, but as usual, I didn't
need
> to know how to do it then, because we weren't using. Flashforward to
today.
> Can someone give me a short explanation of the steps required to setup an
> Excel workbook/worksheet as a datasource, specifically in terms of the
> format that the spreadsheet must be in?
>
> Thanks.
>
> Dave
> ---------------------------
> David E. Crawford
> Director, Internet Development
> Yale Security Group, Inc.
> www.yalesecurity.com
>
> --------------------------------------------------------------------------
----
> 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.
>
------------------------------------------------------------------------------
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.
