Qucik way of data entry

X

x6v87qe

Hi, forum

Got one question. How can I import mass data into a database without losing
validation rules. Currently, I 'm using a form for users to enter the data,
but it is not suitable for mass data. Then I used excel sheet as an
interface, which I lost the validation rules I built within the form. I know
that I can still have validation functions within excel ,but it's a know fact
that copy-past or dragging down defeat those rules.

Is there a quick way for mass data import and still have validations ?

Thanks
niou
 
A

aaron.kempf

you need an ETL tool-- like SQL Server DTS or SSIS

Excel and Access don't have these capabilities
 
B

Brendan Reynolds

x6v87qe said:
Hi, forum

Got one question. How can I import mass data into a database without
losing
validation rules. Currently, I 'm using a form for users to enter the
data,
but it is not suitable for mass data. Then I used excel sheet as an
interface, which I lost the validation rules I built within the form. I
know
that I can still have validation functions within excel ,but it's a know
fact
that copy-past or dragging down defeat those rules.

Is there a quick way for mass data import and still have validations ?

Thanks
niou
Click to expand...


You can define field and table validation rules in table design view (or by
using DDL) and these rules will be applied regardless of how data is put
into the table. There is no way to enforce your form-level validation if
data is not input via the form.

If you can't define the validation rules at the database level, then you
will probably need to import the data 'as is' and then run queries to
identify records that don't conform to the form-level validation rules.
 
Top