Upload the CSV file to an accessible area of the site. Use cfhttp to read the file and retrieve all the records and loop through them.
Delete the file. I think you have a limit of about 2Meg on the file size for cfhttp (correct me if I am wrong). Adam > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: 06 January 2004 11:09 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] Importing... > > > > I want to be able to do this..... > > User names and addresses are entered to a database via a form. > The form consist of name address etc... > Ok this works great for adding an individual record. > > The user now wants to be able to have say 500 records in a text or access > file. > Browse to this file and have the system automatically update the database > with the data. > > > Can this be done via the form? - I know I can import it directly to the > database but I need it via the form online > > Any ideas .... > > Happy New Year. > > Regards - Paul > > > > > ****************************************************************** > ******************************* > The information contained within this e-mail (and any attachment) > sent by Birmingham City Council is confidential and may be > legally privileged. It is intended only for the named recipient > or entity to whom it is addressed. If you are not the intended > recipient please accept our apologies and notify the sender > immediately, or telephone +(44) 121 303 6666. Unauthorised > access, use, disclosure, storage or copying is not permitted and > may be unlawful. Any e-mail including its content may be > monitored and used by Birmingham City Council for reasons of > security and for monitoring internal compliance with the office > policy on staff use. E-mail blocking software may also be used. > Any views or opinions presented are solely those of the > originator and do not necessarily represent those of Birmingham > City Council. We cannot guarantee that this message or any > attachment is virus free or has not been intercepted and amended. > > ****************************************************************** > ******************************* > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
