If you are using SQL Server, you can use DTS
Jay x8453 "Tepfer, Seth" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/13/2007 09:44 AM Please respond to [email protected] To <[email protected]> cc Subject [ACFUG Discuss] moving tables across data sources What is the quick and easy way to copy a table from one data source to another? The table structure exists, it?s just empty. I was thinking of doing some SQL like: INSERT INTO carrierLanesCopy SELECT carrierLanes.* FROM carrierLanes; But then I realized there is no reference to DS in the query itself. Stupid. I don?t want to have to loop over each line of the table, reading and writing. There has to be a better way, right? seth ------------------------------------------------------------- Annual Sponsor - Figleaf Software To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
