spreadsheet column with information you want to import to database. Format
the <textarea> so that it is same width as excel sheet column and long
enough to hold your details from one column of spreadsheet.
User just needs to select the whole column from spreadhseet and paste it to
designated textarea for it.
On your action page you just need to look for chr(13) in each <textarea>
variable to read between each record value.
Cheers
>From: "Eric Dawson" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: Client wants to add data from spreadsheets - HELP!
>Date: Tue, 15 Jun 2004 20:13:09 -0500
>
>I use an online form <textarea> to cut and paste (tab delimited) data from
>excel to a web database.
>
>
>
>I catch the data, and check it for errors, before posting to the database.
>
>
>
>works for me, quick and dirty.
>
>
>
>Eric
>
>
>
> _____
>
>From: Michael Kear [mailto:[EMAIL PROTECTED]
>Sent: June 13, 2004 7:56 AM
>To: CF-Talk
>Subject: Client wants to add data from spreadsheets - HELP!
>
>
>
>I have a client who wants to add records to his database (SQLServer2000)
>from a spreadsheet. He takes his laptop to his seminars and adds the
>attendees details into his excel spreadsheet, then wants to load all that
>data into his SQL database for use in mass emails etc.
>
>My experience with uploading data to a SQLServer table from a spreadsheet
>is
>that it's very finicky. The spreadsheet has to be EXACTLY right or it
>doesn't work. I've found that it omits fields if they are not formatted
>precisely right, and lots of examples of text fields going up as numeric
>and then bombing out half way down the sheet as it encounters text in that
>column.
>
>The client isn't very good at keeping his data consistent, not really
>understanding the difference between column names "EmailAddress" and "Email
>Address" and "<space>Email<space>Address<space>".
>
>In short, I'm looking for another way to pin him down to more consistent
>data collection. What can I do that will make it easier for him to upload
>the data, still allow him to collect it at his seminars, and be able to
>upload the data in a consistent fashion to his Online database without
>having assistance from me every time he does it?
>
>Cheers
>
>Mike Kear
>
>Windsor, NSW, Australia
>
>AFP Webworks
>
>http://afpwebworks.com
>
> _____
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
