Newbie - Filling Tables with Data

Hi

I am writing SQL scripts to define my tables and also fill some of them with
data that are essentially look up tables. One of the tables contains
hundreds of stock items which need to be filled with information.

Is it better to write my INSERT INTO... statements to fill this large table
or better to manually insert the data??

As this solution will be for a small jewellery store which has many
locations and the users cannot be assumed to be advanced-level users, are
there any advantages to writing scripts to fill the tables? (Will be using
MSDE when shipped)

TIA
MichelleI suppose it depends on the user interface you would use to input the data.
Use whichever is quickest and easiest. If you later need to create a script
of INSERT INTO statements you can use this code:
http://vyaskn.tripod.com/code.htm#inserts

Also, consider using DTS to import the data if you have some alternative
electronic source of the data.

--
David Portas
SQL Server MVP
--|||Thank you David for your reply and for the great link also.

No doubt it won't be the last post I put on here.

Michelle

"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:76mdnaugYLHpzS3d4p2dnA@.giganews.com...
> I suppose it depends on the user interface you would use to input the
data.
> Use whichever is quickest and easiest. If you later need to create a
script
> of INSERT INTO statements you can use this code:
> http://vyaskn.tripod.com/code.htm#inserts
> Also, consider using DTS to import the data if you have some alternative
> electronic source of the data.
> --
> David Portas
> SQL Server MVP
> --