Someone really recently had this same sort of issue. Almost exactly, I'm sure. You may consider checking the archives. This discussion took place only a few days ago.
Cheers, Chris Chad Gray wrote: > In the server administrator? I don't see a datatype of excel? > > Nor do I see it in cfquery's dbtype="" attribute. > > I don't understand. > > I want to do this all in a CF page. I don't want to manually import it into > our MS SQL server. > > > > >> -----Original Message----- >> From: Claude Schneegans [mailto:[EMAIL PROTECTED] >> Sent: Thursday, December 21, 2006 11:55 AM >> To: CF-Talk >> Subject: Re: upload excel to update database >> >> >>What about Excel? >> >> Just create a datasource on the Excel file and read it. >> >> -- >> _______________________________________ >> REUSE CODE! Use custom tags; >> See http://www.contentbox.com/claude/customtags/tagstore.cfm >> (Please send any spam to this address: [EMAIL PROTECTED]) >> Thanks. >> >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264758 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4