Entering Data

Question

Entering Data

BuilderBits

SSCertifiable

Points: 6071
More actions
July 25, 2005 at 6:15 pm

#165087

What is the easyest solution to help clients enter data into a form so that i can imported the data into sql2000?

Thanks,
Erik...
Dam again!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Scott-144766 SSCarpal Tunnel Points: 4333 More actions · Answer 1

That depends on an awful lot of things. Assuming your forms environment supports it, do as much data validation as you can (numeric fields only contain numbers, integer fields only contain integers withing the rance of your data type, date fields are all valid dates, text fields don't contain more characters than your destination field). Providing calender selections for date fields always seems to impress my users!

--
Scott

sara karasik SSCommitted Points: 1573 More actions · Answer 2

Excel is great and the fastest - but the forms are standard, and limited in the number of columns.

Access is an easy and fast front-end for SQL Server.

VB, .NET are more upscale choices.

BuilderBits SSCertifiable Points: 6071 More actions · Answer 3

That is what i was hoping to find out with this question.

I am offering a new concept to my industry and alot of these people just do not have the mind set or the know how to help theirself. Even some of the companys that i am selling there products, some of them do not have colors photos of there product line (I AM TALKING ABOUT BIG COMPANYS ALSO).

So i am tring to create an easy (reuseable way for the people to enter data on one end and i work it into sql2000). I am sure that someone who has worked with database development is faced with this lack of coroperation all the time. And creating a front end for every company is not possiablely afforadable.(For the biggest reason they seem to not understand just how much work a front end is).. So, i need to ceate a solution that i know most people are able to work with, like excel,, ect... So they can have their inhouse do this before it gets to me.

I have companys call me every day to sell or market their product line and that is what i am working to is marketing vary nice products (exspecially the smaller companys that are really hungry); however, it is very painfull to enter that much data for each product in their product line. So i need an easy way for them to enter data(So they can help theirself).

Please, any more comments or suggestion about this issue fill free to let me know.

Erik...

Dam again!