Technology Insights

How To Export From PGAdmin, Export PGAdmin Data To CSV

This afternoon I was using PGAdmin and needed to export some data from a query I had run but realized I wasn’t even sure if PGAdmin had this capability. Typically I would export data using the PSQL command line but since I was already working in PGAdmin I wanted to try and figure out if the capability existed and if so how to do it. After some playing around I was able to figure out how to export PGAdmin data to a CSV (Comma Separated Value) format that would be Microsoft Excel friendly. Follow the directions below to export PGAdmin data to a .CSV file to open in MS Excel.

Technology Insights

Use Microsoft Excel to Populate Cells on a Second Worksheet in the Same Workbook

If you have an Microsoft Excel workbook with multiple worksheets that contain similar type data it may save you a lot of time to auto populate the other worksheets with the similar data. In my scenario I had a form used to obtain information about customers which needed to be in a certain format but then I had two other forms that had some of the same data that needed to be provided to other departments. So the initial process was to fill out each individual form by hand and send to the proper department. To save time I wanted to auto populate as many like fields as possible.

The resolution ended up being really simple. First I just added the other forms to the workbook of the primary form. This ensured that when I opened up the form to enter customer data that the other two forms were open with t. Once I had added the worksheets and named each one properly I started messing around with formulas to complete the task of copying one cell from the primary worksheet to cells on the second and third worksheets in this workbook.

Technology Insights

How to Merge Multiple Excel Fields Together, Merge Excel Cells Together

Its fairly easy to merge Microsoft Excel fields together but you have to be aware of formulas and then with how to pull that data out of the formula to save it on its own. I used this to merge title, first name, and last name together. Follow the directions below and you should have no problems merging Excel fields together.

1. New Column: Add the below formula to a new column.

=CONCATENATE(A1,” “,B1,” “,C1)

Microsoft Excel Formula for Merge

Technology Insights

Export Outlook Contacts to Excel or Export Windows Mail Contacts to Excel

Below is a step by step guide to export your Microsoft Outlook contacts to Excel as well as a step by step guide to export your Windows Mail to Excel. If you are running Windows Vista follow the Windows Mail steps and any other Windows version, including Windows XP, should use the Microsoft Outlook steps.

 

Export Contacts from Windows Mail to Excel:

  1. Open Windows Mail: Click Start Icon, Click All Programs, Choose Windows Mail
  2. Select Contacts: From Windows Mail Select Tools, Select Windows Contacts, Left Click Windows Contacts.
  3. select-contacts