import into more than 1 table

Hi everyone,
im trying to import data using a query...how ever i can only insert data into one table, and i need to insert data into many...this is at the part where you map the fields...
is there a way to do this? or something similar?
Thanks, Justinyou could export your data to a flat file using bcp, then import that file to as many destinations as you like, again using bcp.|||you could export your data to a flat file using bcp, then import that file to as many destinations as you like, again using bcp.

hi, and thanks for your reply...

but im not sure what bcp is?

Thanks, Justin|||Open up Books Online (or press F1 from the Query Analyzer screen) ... click on the INDEX tab ... type bcp ... peruse the various topics ... click on bcp utility for the syntax ... give it a try.