do it.
>
>Just my $0.02
>
>Dan Phillips
>CFXHosting.com
>
>-Original Message-
>From: Alex [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, September 05, 2001 10:04 AM
>To: CF-Talk
>Subject: Re: Excel as a datasource ?
>
>
>excel as a datasource w
try caching the tables so the time to pull off the queries goes down
dramatically.
-Original Message-
From: Dan Phillips [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 10:15 AM
To: CF-Talk
Subject: RE: Excel as a datasource ?
I agree. Down the road it's going
Thursday, September 06, 2001 1:28 AM
To: CF-Talk
Subject: RE: Excel as a datasource ?
I have to agree with this -- my experience is that going low-end on the data
store always proves to be a bad decision in the long run.
One note on Excel that I haven't seen posted in this thread: I ha
At 1:09 PM +0200 9/5/01, Admin wrote:
>I've had good luck using an access database with tables linked to the excel
>sheets. This way you can use all the features of access like views etc and
>you can swap out the excel file without having to worry about the file being
>locked by the cf server.
Th
01 10:04 AM
To: CF-Talk
Subject: Re: Excel as a datasource ?
excel as a datasource would make maintainability, scalability, and
enhancements alot harder and in the long run cost more. Actually, at one
place I worked at we charged more if the client wanted to use Access over
SQLServer (I assume
er 05, 2001 10:04 AM
To: CF-Talk
Subject: Re: Excel as a datasource ?
excel as a datasource would make maintainability, scalability, and
enhancements alot harder and in the long run cost more. Actually, at one
place I worked at we charged more if the client wanted to use Access over
SQLServer
excel as a datasource would make maintainability, scalability, and
enhancements alot harder and in the long run cost more. Actually, at one
place I worked at we charged more if the client wanted to use Access over
SQLServer (I assume excel as a datasource would cost even more).
On Wed, 5 Sep 200
EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 9:54 PM
To: CF-Talk
Subject: RE: Excel as a datasource ?
Mike;
Take a look at www.fdford.com I use an Excel spreadsheet on that site due to
the
client wanting easy updating abilities. It seems to work without flaw as
long as
the client keep
Mike;
Take a look at www.fdford.com I use an Excel spreadsheet on that site due to
the
client wanting easy updating abilities. It seems to work without flaw as
long as
the client keeps all of thier data inserted properly.
Larry & Sheila Juncker
Fort Dodge, IA
-Original Message-
From: M
I've had good luck using an access database with tables linked to the excel
sheets. This way you can use all the features of access like views etc and
you can swap out the excel file without having to worry about the file being
locked by the cf server.
- Original Message -
From: "Mike Kea
change 1-1-10$ to "1-1-10$"
see what happens.
-Original Message-
From: Brian Thornton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 2:18 AM
To: CF-Talk
Subject: Excel as a datasource.
I have...
SELECT *
FROM 1-1-01$
This is a query for a excel sheet. I'm getting a err
The file the ODBC source points to has probably moved, or has the wrong
priv.'s.
> -Original Message-
> From: Brian Thornton [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 11, 2001 10:18 AM
> To: CF-Talk
> Subject: Excel as a datasource.
>
>
> I have...
>
> SELECT *
> FROM 1-1-
> I have...
>
> SELECT *
> FROM 1-1-01$
>
>
> This is a query for a excel sheet. I'm getting a error S1000
> saying "[Microsoft][ODBC Microsoft Access Driver] Cannot open
> database '(unknown)'. It may not be a database that your
> application recognizes, or the file may be corrupt."
>
> Any i
> Anyone know of a references for this?
OK, warnings I've given before (in Aidan's FAQ);
The ODBC source points to the file. The "table name" is the sheet name with
a $ on the end, but always put square brackets around it; [Sheet1$]
Row 1 MUST, I repeat, MUST be the column names
Once a column
cfcomet.com have load of information about this sort of Object instantiation
etc...
N
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-
What are you after ? You import it into Access, save the .mdb, and add it as
an ODBC...
-Original Message-
From: Brian Thornton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 7:16 AM
To: CF-Talk
Subject: Excel as A DataSource
Anyone know of a references for this?
~~
16 matches
Mail list logo