I deal a lot with Excel and SQL and routinely use CF for data input and output. I like Excel for data entry because it is so flexible. If you want to get fancy try what I did: write a simple vba function in Excel that creates an xml file. Then write a CF script to upload the data into SQL Server
I use the excel sheet technique and it works well and very easy. Create a tag for each spreadsheet column with information you want to import to database. Format the so that it is same width as excel sheet column and long enough to hold your details from one column of spreadsheet.
User just need
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 to cut and paste (tab delimited) data from
>excel to a web database.
>
>
>
>I catch the data, and check it for e
I use an online form 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-Ta
>>I have a client who wants to add records to his database (SQLServer2000)
from a spreadsheet.
I have made a similar solution, and to make sure it works, this is the approach I took:
- define the Excel template in order to have the field names in the first row, and lock the row.
- define a datasou
There is a way to do it fairly gracefully. If you download the Office XML DOM, you can use it to extract data from Excel (and put it back) if you have a well-formatted spreadsheet. Make sure everything but the input fields are locked and read-only. I had a colleague who did this a couple of years a
I would design a custom web app for him to do it in. Try to get him to an all web based solution.
Or even a client side vb/java/python etc application...
- Original Message -
From: Qasim Rasheed
To: CF-Talk
Sent: Sunday, June 13, 2004 3:46 PM
Subject: RE: Client wants to add
I guess using Access it a another option.
Qasim
-Original Message-
From: Michael Kear [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 13, 2004 8: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 (SQLServ
Instead of him using an excel spreadsheet, try getting him to use an Access
database instead. You can create a form that he'll use to populate the
fields and then he'll have a (more) structured data input tool. I've had to
do that several times to get folks away from excel.
Jeff Garza
_
9 matches
Mail list logo
