ReadExcel.cfm Error

[Ren0420]

Hi,

I'm trying to read an Excel file into CF using Ben Forta's ReadExcel.cfm in AM
CFMX7 AD, but am getting the error below. I've tried DATABASE=Sales.xls (moved
xls to same dir as cfm). Eventually this file will be used to update a DB.

Where is there more info on this special type of FROM?

I'm also trying to automate reading this Excel file from an IMAP email. Since
there is no cfimap with documentation, any suggestions? I'm working with
another group that can't use WDDX or web services for about another year :(

Thanks,
Ren

**************************************

Error Executing Database Query.
'"Excel 8.0;
DATABASE=C:\CFusionMX7\runtime\servers\coldfusion\ SERVER-INF\temp\wwwroot-tmp\xl
s7950245909443315931.tmp; HDR=YES"' is not a valid name. Make sure that it does
not include invalid characters or punctuation and that it is not too long.

The error occurred in
C:\Inetpub\wwwroot\rapdir_workingcopy_florencio\27 \ReadExcel.cfm: line 53

51 : <cfquery name="excelData" datasource="proxy">
52 : SELECT Salesperson, SalesAmount
53 : FROM "Excel 8.0; DATABASE=#tempFile#; HDR=YES".
54 : </cfquery>
55 :




--------------------------------------------------------------------------------

SQL SELECT Salesperson, SalesAmount FROM "Excel 8.0;
DATABASE=C:\CFusionMX7\runtime\servers\coldfusion\ SERVER-INF\temp\wwwroot-tmp\xl
s7950245909443315931.tmp; HDR=YES".
DATASOURCE proxy
VENDORERRORCODE 3092
SQLSTATE &nbsp;

Please try the following:

[plarts]

I am looking for a technic to read Excel sheets,
do you know where I can get this file : ReadExcel.cfm
from Ben Forta.
Is that technic good ?

I looked inside Adobe site, I found nothing,
I looked insite Ben Forta site, I found nothing

Thanks for the information.

Pierre.

[Ren0420]

Pierre,

ReadExcel.cfm works fine; see
[url]http://forums.forta.com/messages.cfm?threadid=E628832C-3048-80A9-EF4BDFBE4CE4ED1[/url]
3. The file is also on Ben's site
[url]http://www.forta.com/books/0321292693/0321292693_27.zip[/url].

What would a good detective do?

Beware of numbers as text (phone numbers). After I imported to SQL Server 2k,
some showed in exponential notation (8.00555e+0 instead of 8005551212). Also
Access has problems reading a column of alternating letters, numbers, and empty
cells.

Kind regards,
Ren

[rizalfir]

Pierre,
i have a CFX that will read/write Excel binary files without having to setup
DSN and all.

You might be interested to look at it:

[url]http://www.masrizal.com/index.cfm?fuseaction=idea.download_detail&ProductI D=cfx_[/url]
excel

Live example also available to read and write your Excel document.