Actually, you can specify the excel file you want right in the query,
like this:
SELECT
[INVOICE AMOUNT] as InvAmount,
[INVOICE NUMBER] as InvNumber,
[ORDER NUMBER] as OrderNum,
[PAID AMOUNT] as PaidAmount,
[BALANCE DUE] as BalDue,
[COMMENTS] as Comment
FROM
`data$`
IN
'd:\webroot\reports.net\baldue\temp\#cffile.serverFile#'
'EXCEL 5.0;'
WHERE
[ORDER NUMBER] > 0
'data$' is the workbook name inside your spreadsheet, and the rest
should be obvious =)
So, just setup your DSN as a generic Excel ODBC datasource (I named mine
Excel, aint I creative?) and query away!
Chris Peterson
-----Original Message-----
From: Christopher Jordan [mailto:[EMAIL PROTECTED]
Sent: Monday, December 18, 2006 3:40 PM
To: CF-Talk
Subject: Re: Best way to read in Excel/CSV files
I'd connect to it as a data source, I think. It's just less for the
client to do. Of course, the file will have to be named the same thing
each time, else you'd have to create a new DSN each time for each
differently named file.
Check out their type 4 JDBC Excel driver <http://hxtt.com/excel.html>
available on www.HXTT.com <http://hxtt.com>. I'm currently using their
Type 4 DBF driver for visual FoxPro, and it works like a champ. The
developers, are very ready to help any of their users via email. I've
never used their text drivers, but I imagine they're not too hard to get
the hang of.
Hope this helps.
Cheers,
Chris
Andy Matthews wrote:
> I have a client who wants me to build a quick admin tool for him. It
would
> allow him to upload 2 files from different dates and list the
differences.
> It's bascially two Excel files with 4 columns each and about 9000
lines
> apiece.
>
> So my question is, would it be better to connect to the Excel file as
a
> datasource or have him convert to a CSV text file and upload that way?
He'll
> be using this tool each day to compare the current day's file to the
> previous day's file.
>
> <!----------------//------
> andy matthews
> web developer
> certified advanced coldfusion programmer
> ICGLink, Inc.
> [EMAIL PROTECTED]
> 615.370.1530 x737
> --------------//--------->
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:264364
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
