Here instead of selecting a prpoer version u can use Excel 8.0 which reads
all excel formats ...
> 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.
>
------------------------------------------------------------------------------
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.
