file from the CD.
Worked great, but it is quite a kludge. :)
> -Original Message-
> From: Claude Schneegans [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 21, 2006 2:20 PM
> To: CF-Talk
> Subject: Re: upload excel to update database
>
> >>In MS Acces
>>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 may be wrong, but I think that the datasource points to a directory in
which every .xls file is considered as a table. Then the query goes li
>>In MS Access do an external link to an Excel file.
This could work also, but the problem is that the link is an absolute
path to the file on your disk.
At least, I've never found a way to make it relative to the main
database, then it will not work when you transfer the database on your
serv
le.
>
> Thanks for the help!
>
>
>
>
>> -Original Message-
>> From: Christopher Jordan [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, December 21, 2006 1:22 PM
>> To: CF-Talk
>> Subject: Re: upload excel to update database
>>
>> I t
!
> -Original Message-
> From: Christopher Jordan [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 21, 2006 1:22 PM
> To: CF-Talk
> Subject: Re: upload excel to update database
>
> I think it's supposed to be the name of the worksheet... which it looks
> li
on, Chris [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, December 21, 2006 12:44 PM
>> To: CF-Talk
>> Subject: RE: upload excel to update database
>>
>> Use Sheet1$
>>
>> -Original Message-----
>> From: Chad Gray [mailto:[EMAIL PROTECTED]
>> Sent
cember 21, 2006 12:44 PM
> To: CF-Talk
> Subject: RE: upload excel to update database
>
> 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 up
ilto:[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
> worksh
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
o:[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
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
s [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.
>>
>> --
>&g
>>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 Windo
> 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.
>
> --
>
>>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.
~~
If they're using Excel 2003, then they're able to save the file as XML
and they could upload that for you to parse over.
Just a thought. :o)
Cheers,
Chris
Chad Gray wrote:
> Anyone have any good ideas on letting a user upload an Excel sheet so they
> can update a database table?
>
> I can see
Anyone have any good ideas on letting a user upload an Excel sheet so they can
update a database table?
I can see how I could do this with CSV. Just us CFFile to read in the data and
loop over it to update/insert into the database table.
What about Excel?
17 matches
Mail list logo