How to Export a Table

Often times you have a need to export a table from SQL Server into another format.  The most common of these is Excel, CSV (Comma Separated Value), Access, or even to another SQL Server.  Luckily, there is one tool native to SQL Server that can export to all these formats, the SQL Server Import and Export wizard.

To start this wizard, simply right-click on the database that contains the table you want to export within Management Studio, then select Tasks -> Export Data.

Export Table SQL Server


What pops up next is the SQL Server Import/Export Wizard.  Select next to get past the splash screen then choose the data source.  This is going to be the same data source as the database you selected to export the table from.  Once you select the ServerName and Database name, select next.

Next you want to choose the destination.  This is where multiple export options come in.  You can choose any of the options that appear in the destination drop down box.  Once you select the export file type and file location, you will then be prompted to select the tables to output, along with additional options.  This will assist you in outputting many different export formats for your table.

One comment
Mera 31 Aug 2015 at 9:25 am

Yes. Using the Free Trade Zone in Colon, (the second lgseart in the world after Hong Kong) you can drop ship in container sized shipments more efficiently and at less cost than any other port to other port cities in the Caribbean or South America. (You might also consider shipping from Colon to Limon, Costa Rica’s only Caribbean Port. Costa Rica and Panama have just signed a free trade agreement.)BUT it does depend on what kind of goods you are selling and what the market is in each of the three islands that you wish to sell to. Will you be competitive? Do you have a product that they want?Do you have sales reps in each island? Or a sales rep who will travel and sell. Nothing can happen until you have a sales order. And it takes shoe leather to get the order when you’re new. After you get buy-sell relations started, and get return orders, you will have a stable business. There are many of this type operating out of Colon, taking advantage of the location and the Free Trade aspect.Good luck! It’s a good idea.

Featured Articles

 Site Author

  • Thanks for visiting!