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\myExcel.xls' 'EXCEL 5.0;'
</cfquery>
SELECT *
FROM [Sheet1$]
IN \\myColdFusionServerFilePath\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: CFCDev@cfczone.org
Subject: RE: [CFCDev] Web Based import
You can still dynamically add datasources. Have a look
at:
/Cody
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Roberts
Sent: Friday, February 24, 2006 10:56 AM
To: CFCDev@cfczone.org
Subject: Re: [CFCDev] Web Based import
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]> 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]] On Behalf Of David Mineer
> > Sent: Friday, February 24, 2006 12:06 PM
> > To: cfcdev@cfczone.org
> > 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 cfcdev@cfczone.org 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/cfcdev@cfczone.org
> >
> >
> >
>
>
>
> ----------------------------------------------------------
> You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org 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/cfcdev@cfczone.org
>
>
>
--
[EMAIL PROTECTED]
http://blog.rawlinson.us
If you want Gmail - just ask.
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org 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/cfcdev@cfczone.org
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org 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/cfcdev@cfczone.org ----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org 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/cfcdev@cfczone.org ----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org 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/cfcdev@cfczone.org
