remember, you can read/write Excel files using POI very easily with CF,
(just look at all the commenters on this post I made a while back:
http://www.d-ross.org/index.cfm?objectid=9C65ECEC-508B-E116-6F8A9F878188D7CA
)
-Dave
>>> [EMAIL PROTECTED] 02/24/06 3:18 PM >>>
As long as at least one MS Access data source exists on your CF server,
you do not have to set up a new datasource.
You can actually just query the excel spreadsheet... however if the
spreadsheet contains any Formulas it may cause a problem. To do this
you need to:
1. Know any MS Access Datasource name: ie 'RandomMSDSN'
2. Know the Sheet name in the excel file... usually it will be Sheet1
3. The first row of the spreadsheet should be column headers and should
start with a letter and should not contains spaces, only _
4. You are going to need to place the file somewhere the coldfusion
server
Example
<cfquery name="qryReadExcel" datasource="'RandomMSDSN'">
SELECT *
FROM [Sheet1$]
IN \\myColdFusionServerFilePath\
<file://\\myColdFusionServerFilePath\myExcel.xls'> myExcel.xls' 'EXCEL
5.0;'
</cfquery>
Brendan
________________________________
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Cody Caughlan
Sent: Friday, February 24, 2006 1:03 PM
To: [email protected]
Subject: RE: [CFCDev] Web Based import
You can still dynamically add datasources. Have a look at:
http://spike.oli.tudelft.nl/jochemd/index.cfm?PageID=12
/Cody
________________________________
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Daniel Roberts
Sent: Friday, February 24, 2006 10:56 AM
To: [email protected]
Subject: Re: [CFCDev] Web Based import
I think you have to use the CF Admin API to setup datasources now.
On 2/24/06, Bill Rawlinson <[EMAIL PROTECTED] > wrote:
I recently tried the dynamic datasources with excel and as
previously
mentioned it doesn't seem to work with MX. However dynamic
datasources
with Access do still work.
and BULK INSERT is your friend. Follow their advice.
Bill
On 2/24/06, Gabriel Roffman < [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> > wrote:
> It you need to deal with Excel files, I have used this
successfully for a
> while.
>
> http://www.cftagstore.com/tags/cfxexcel2query.cfm
>
> You can find information on usage here.
> http://emerle.net/programming/help/installing_cfx.cfm
>
> Gabe Roffman
> eTesters
>
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto: [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> ] On Behalf Of David Mineer
> > Sent: Friday, February 24, 2006 12:06 PM
> > To: [email protected]
> > Subject: [CFCDev] Web Based import
> >
> > I want to create an application in Cold Fusion that would
> > allow someone to select a csv or excel file from their
> > computer and import into MSSQL which resides on my server.
> > They would need options to map fields, make changes (i.e.
> > strConv(field1,3) or left(field1,5) ) and even save a
profile
> > once they had it right.
> >
> > Currently, the user has to send me the file, I import into
an
> > access table, create an append query and then use DTS to get
> > it into SQL. I would really like to shift this work to the
user.
> >
> > Can someone point me in the right direction to some material
> > that can get me going on this. Any pointers or experience
> > from having done something like that yourself.
> >
> > Any comments would be appreciated.
> >
> > Thank you,
> >
> > --
> > David Mineer Jr
> > ---------------------
> > The critical ingredient is getting off your butt and doing
> > something. It's as simple as that. A lot of people have
> > ideas, but there are few who decide to do something about
them now.
> > Not tomorrow. Not next week. But today. The true
entrepreneur
> > is a doer.
> >
> >
> > ----------------------------------------------------------
> > You are subscribed to cfcdev. To unsubscribe, send an email
> > to [email protected] with the words 'unsubscribe cfcdev' as
> > the subject of the email.
> >
> > CFCDev is run by CFCZone (www.cfczone.org) and supported by
> > CFXHosting (www.cfxhosting.com).
> >
> > An archive of the CFCDev list is available at
> > www.mail-archive.com/[email protected]
> >
> >
> >
>
>
>
> ----------------------------------------------------------
> You are subscribed to cfcdev. To unsubscribe, send an email to
[email protected] with the words 'unsubscribe cfcdev' as the subject of
the email.
>
> CFCDev is run by CFCZone (www.cfczone.org) and supported by
CFXHosting (www.cfxhosting.com).
>
> An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
>
>
>
--
[EMAIL PROTECTED]
http://blog.rawlinson.us
If you want Gmail - just ask.
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to
[email protected] with the words 'unsubscribe cfcdev' as the subject of
the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by
CFXHosting ( www.cfxhosting.com <http://www.cfxhosting.com> ).
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to
[email protected] with the words 'unsubscribe cfcdev' as the subject of
the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting
(www.cfxhosting.com).
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to
[email protected] with the words 'unsubscribe cfcdev' as the subject of
the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting
(www.cfxhosting.com).
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to
[email protected] with the words 'unsubscribe cfcdev' as the subject of
the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting
(www.cfxhosting.com).
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
-----------------------------------------
CONFIDENTIALITY NOTICE: This email and any attachments may contain
confidential information that is protected by law and is for the
sole use of the individuals or entities to which it is addressed.
If you are not the intended recipient, please notify the sender by
replying to this email and destroying all copies of the
communication and attachments. Further use, disclosure, copying,
distribution of, or reliance upon the contents of this email and
attachments is strictly prohibited. To contact Albany Medical
Center, or for a copy of our privacy practices, please visit us on
the Internet at www.amc.edu.
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to
[email protected] with the words 'unsubscribe cfcdev' as the subject of the
email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting
(www.cfxhosting.com).
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
