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]
