[SQL] Exporting Vendors

[trygon11]

Ok so ive made about 40 vendors ive had to add every item to the DB im working with it was long hard and frustrating, and theres still more to go, but ive found a repack that has all the items in it that im gonna need which will make things much easier, so im wondering how i can export my current ones via SQL and just load them into this new one?

[Sparta12]

Ok so ive made about 40 vendors ive had to add every item to the DB im working with it was long hard and frustrating, and theres still more to go, but ive found a repack that has all the items in it that im gonna need which will make things much easier, so im wondering how i can export my current ones via SQL and just load them into this new one?

Are you using Oracle?
Also you did not bother to make vendors in an SQL batch file and execute them?