Sounds like you need them to be able to build the table fields and
structure. A little more than what I do, but I do suggest using MS SQL
Bulk Insert command to bring the file into the database
Here is what I do
CREATE TABLE ##temp (x varchar(100));
BULK INSERT ##temp FROM '#application.directory##attributes.spreadsheet#'
WITH (FIELDTERMINATOR = ',',ROWTERMINATOR = '\n');
application.directory is the directory where the file is upload to (via
cffile command)
and attributes.spreadsheet is the file name
It has to be a CSV file (or other delimited file). It can't be an excel
file.
Jason Cronk
Verizon
"David Mineer"
<[EMAIL PROTECTED] To: [email protected]
> cc:
Sent by: Subject: [CFCDev] Web Based
import
[EMAIL PROTECTED]
one.org
02/24/2006 12:06
PM
Please respond to
CFCDev
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]
