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.
