11
Aug
·
Wed
2010
Biow Tutorial: How to append cell values in Excel, how to add single quote to a list for sql query
Many times during programming, we may need to do some sql query. Be it to insert some pre-loaded values or to retrieve some results.. and we were given a list of names, to find out perhaps their address, title, etc from a table.. what is the easiest way? I find Excel is the solution for me.. here's how to do it.. you may download this file in Excel to better understand my explaination.
| Step1: |
 |
| Result: |
 |
(2010-08-11 11:05:09 SGT) [biow's tutorial] Permalink
sql
ms_excel
office2003
Comments:
Post a Comment:
Comments are closed for this entry.
Most popular blog postings in Biow's world:
- 2010 O-Levels cut off point to JC (Junior College) in Singapore
- Sengkang Swimming Complex
- Recipe: Honey Vanilla Pound Cake Recipe by Ina Garten of Barefoot Contessa
- Fisheye effect with Photoshop CS 3
- Digital photography tutorial for Nikon D40 DSLR
- Canon DSLR Tutorial Guide for Beginners
- Watch Korean Dramas online for FREE.. Feeding your drama addiction..
- more links to watch korean dramas online free with subs
- Korean Drama: The Legend (Tae Wang Sa Shin Gi) by Bae Yong Joon Episode Guide
- resignation letter for less than tender notice sample
Featured articles in Biow's world:
- Singapore Maths P1 Worksheet Online Generator - Problem Sums
- Singapore Maths P2 Worksheet
- Canon DSLR Tutorial Guide for Beginners
- Cake Decoration 101 - How to cream / frost a cake
- Cake Decoration 101 - Shell Piping
- Freezing Expressed Breastmilk (EBM) in 3 steps
- Another way to freeze Expressed Breastmilk (EBM)
- Storing of Expressed Breastmilk (EBM)
- How Breastfeeding Benefits Add Up
- Do not use glass bottle to freeze your precious breastmilk
