Thanks. I think I have figured it out. I would do it in access, but the
bean counters love spreadsheets, so I am forced to go along with them on
this.
Dave
----- Original Message -----
From: Steve Robson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 28, 2000 13:45
Subject: RE: Excel Workbook/Worksheet as Datasource
> This is based on my experience, and so may not be the best way to do
> this:
>
> you need to create named ranges in the workbook, these ranges become
> tables
> and the first row becomes the field names. That's pretty much about it,
> set
> up a datasource to point to the file and Bob's your uncle!
>
> I found it to be a total pain, and so ended up converting the
> spreadsheet
> into an access database and just used that instead!!
>
> Steve Robson
>
> -----Original Message-----
> From: David E. Crawford [mailto:[EMAIL PROTECTED]]
> Sent: 28 March 2000 14:24
> To: CF-Talk
> 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.
