Do you need to export contacts for use elsewhere or in other software? Microsoft provides a way to directly export data from the SQL database using the "Import and Export Data" wizard. 

You can locate this in Windows from Search by typing "export" or by navigating to Start > All Programs > Microsoft SQL Server 2012 > Import and Export Data (32-bit)

The SQL Server Import and Export Wizard appears.  Click Next

On Choose a Data Source, use SQL Server Native Client, with Server set to the THREED instance, specify the Database "InspectionData".  Click Next

On Choose a Destination, adjust the "Destination" field to the desired program you wish to export directly to or to Flat File.

e.g. If you wish to export directly into Excel or Access you may do so. Use Browse to specify the desired folder and filename.  See also http://www.mssqltips.com/sqlservertutorial/202/simple-way-to-export-data-from-sql-server/ ).  To export to a delimited file, choose Flat File.  Use Browse to specify the folder, filename, and file type. See also http://databases.about.com/od/sqlserver/a/Importing-And-Exporting-Data-With-Sql-Server-2012.htm

On Specify Table Copy or Query, choose Copy data from one or more tables or views.

On Select Source Tables and Views, we do not recommend exporting direct tables [dbo].[tbl*] type items, but suggest export Views (items without tbl prefix) as they contain appropriate join information e.g. to export all contacts, [dbo].[ContactList], to export jobs [dbo].[JobList]

TIP: Use Preview after selecting a View to see the specified information to export.

Finish the wizard as needed to complete your export.  Now you may work with the data that you have exported or use it in another program. You may want to check with the program you plan to use to see what sort of format it can most easily import or work with. Note that some programs may also be able to connect directly to the SQL data as a data source.


Note that you may use the same concept and tool to export a list of your invoice product fees.  In that case you might use the Import and Export wizard to export the [dbo].[JobInvoiceList] table from the database which would contain your fee listing.