If you have an instance of SQL Server 2000 somewhere, use DTS to import the data in. You can transform and massage the data after that.
Teddy On 12/21/06, Peterson, Chris <[EMAIL PROTECTED]> wrote: > > Use Sheet1$ > > -----Original Message----- > From: Chad Gray [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 21, 2006 12:44 PM > To: CF-Talk > Subject: RE: upload excel to update database > > Actually if I make a system dsn in windows linking to the Excel file > then hook this into CF administrator. What is the table name of the > worksheet? > > I tried the following and no luck > <cfquery datasource="excelTest" name="test"> > SELECT * > FROM Sheet1 > </cfquery> > > Also my MS Access idea linking to the excel it appears that if you > update the excel file and query the datasource again the updated data in > the excel file does not appear. I wonder if it is being cached and how > to purge it. > > > > > -----Original Message----- > > From: Chad Gray [mailto:[EMAIL PROTECTED] > > Sent: Thursday, December 21, 2006 12:30 PM > > To: CF-Talk > > Subject: RE: upload excel to update database > > > > Oh.... I see what you are saying... make the DSN in windows... then > hook > > into that with the Administrator... This works for me and is better > then > > what I tried below. > > > > In MS Access do an external link to an Excel file. Now the excel > sheet is > > in Access as a table that I can query with CF. I haven not tried > changing > > or updating the excel file to see what happens to the data returned in > CF, > > but it might work. > > > > > > > > > > > -----Original Message----- > > > From: Claude Schneegans [mailto:[EMAIL PROTECTED] > > > Sent: Thursday, December 21, 2006 12:15 PM > > > To: CF-Talk > > > Subject: Re: upload excel to update database > > > > > > >>In the server administrator? I don't see a datatype of excel? > > > > > > Aaaah this is the "pleasure" of working with JDBC! :-( > > > I suppose you're under CFMX, under CF 5 all ODBC drivers were > available, > > > including Excel. > > > > > > With CFMX, you need to first create an ODBC datasource on your Excel > > > file from Windows. > > > THEN you can create the JDBC datasource on that ODBC DSN in the CF > > > Administrator using the ODBC socket. > > > > > > I think MM should have kept the ODBC connection creation tool in the > > > administrator and connect the datasource automatically through the > ODBC > > > socket. > > > > > > Now, if you're uner Unix or Mac, that's even another story. > > > > > > -- > > > _______________________________________ > > > 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:264774 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
