Easy way to Load Data into tables?
Posted on 2005-04-24
I wanted to know if someone can tell me the easiest way to load data into newly created tables.
Certain tables like "States", "Countries" i need to constantly reload and reload each time I create my databases.
I have maybe 10-20 tables that should have "canned" data in them when the tables are created. I would like to have just one script that I can run that will populate the tables.
I suppose DTS could do something like this, but I was looking to have it all in one .sql file.