Entries tagged [sql]

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: