Saltar al contenido
PROGRAMAR EN VBA MACROS DE EXCEL

Excel y SQL principales sentencias

(adsbygoogle = window.adsbygoogle || []).push({});

Anteriormente mostre como conectar Excel con Access, en esa oportunidad se ingresaron datos desde Excel y se guardaron en Access usando el comando recorset; en esa oportunidad había mencionado que se puede obtener el mismo resultado ejecutando sentencias SQL, en esta entrega te muestro algunas de las sentencias SQL más comunes, esto nos servirá de apoyo para las siguientes presentaciones, donde se mostrará como conectar Excel con Access, pudiendo manipular desde Excel los registros de Access, es decir se podrá, insertar, modificar, borrar o consultar registros de la tabla de Access mediante SQL y mostrarlos en una hoja de Excel, en otras palabras se podrá manipular tablas de Access desde Excel.

Si estás usando macros, o necesitas modificar alguna de ellas para automatizar tu libro de Excel seguramente te es necesario saber seleccionar o referenciar celdas, en FORMAS DE SELECCIONAR O REFERENCIAR CELDAS CON VBA (Spanish Edition) encontrarás una excelente ayuda; si trabajas con fechas en Excel, fíjate en el siguiente link que te puede ser de utilidad FORMATOS Y FUNCIONES DE FECHA Y HORA DE MICROSOFT EXCEL (Spanish Edition)

  

Antes de profundizar te recomiendo que leas un excelente libro sobre Excel el que te ayudará operar las planillas de cálculo, haz click acá, si quieres un libro sobre Excel, en inglés, entonces debes hacer click acá. Si lo que necesitas es aprender o profundizar sobre la programación de macros con VBA este es unos de los mejores cursos on line que he visto en internet.

Desde el link final podrás descargar el ejemplo que conecta Excel con Access y cientos de ejemplos totalmente GRATUITO, recordando que si este o alguno de los ejemplos publicados te fueron de utilidad y puedes, aporta a seguir manteniendo esta página.

Como había mencionado más arriba estas son algunas de las sentencias SQL que se pueden utilizar en Excel al trabajar con Access, en las siguientes entregas mostraré como filtrar datos trabajando con el comando SELECT y como insertar o agregar datos, modificar y eliminar datos.

Antes que nada es preciso definir que es SQL, bien SQL es un lenguaje de consulta estructurado, se podría decir que es un lenguaje de base de datos normalizado que es utilizado por el motor de base de datos de Microsoft Jet.

Se utiliza SQL para crear objetos QueryDef que son el argumento de origen de datos del método OpenRecorsSet y como la propiedad RecordSource de un control de datos, también es usado para crear y manipular directamente una base de datos con el método Execute o crear consultas SQL de paso para manipular bases de datos remotas.

Que compone el lenguaje SQL, la respuesta es un conjunto de comandos, cláusulas, operadores y funciones de agregado, que se combinan entre si en las denominadas sentencias SQL para poder  manipular una base de datos, es decir crear, actualizar o consultar la misma.

Existen dos tipos de
comandos SQL los denominados DLL y DML los permiten crear una nueva base de
datos, definir campos e índices; los DLL permiten generar consultas para
filtrar y extraer datos de la base.
COMANDOS

 COMANDOS DLL
Comando
Descripción
CREATE
Crear
nuevas tablas, campos e índices.
DROP
Eliminar
tablas e índices.
ALTER
Modifica
tablas agregando campos o cambiando la definición.
 COMANDOS DML
Comando
Descripción
SELECT
Sirve
para consultar registros que cumplan un criterio determinado.
INSERT
Sirve
para cargar lotes de datos en la base de datos en una única operación.
UPDATE
Sirve
para modificar los valores de los campos y registros especificados.
DELETE
Utilizado
para eliminar registros de una tabla de una base de datos.
CLÁUSULAS
Son condiciones
que se utilizan para definir que datos se desea seleccionar o manejar.

Cláusula
Descripción
FROM
Determina
la tabla de la cual se van a seleccionar los registros.
WHERE
Sirve
para especificar que registros se deben seleccionar.
GROUP BY
Utilizada
para separar los registros seleccionados en grupos específicos.
HAVING
Utilizada
para expresar la condición que debe satisfacer cada grupo.
ORDER BY
Sirve
para ordenar registros de acuerdo a un criterio seleccionado.


OPERADORES
LÓGICOS
Son los
siguientes:
Operador
Descripción
AND
Es el
«y» lógico. Evalúa dos condiciones y devuelve un valor de
verdad sólo si ambas son ciertas.
OR
Es el
«y» ó «o» lógico. Evalúa dos condiciones y devuelve un
valor de verdad si alguna de las dos es cierta.
NOT
Negación lógica.
Devuelve el valor contrario de la expresión.
XOR
Es el
«o» lógico devuelve los registros que cumplan una u otra condición
pero no amas condiciones como en el caso de or.
EQV
Devuelve
verdadero si dos expresiones son verdaderas o son las dos falsas.
IMP
Compara
dos objetos, también es denominada IS

 

OPERADORES
DE COMPARACIÓN
Permiten comparar
dos o más expresiones.
Operador
Descripción
Menor que
Mayor que
<> 
Distinto
de
<=
Menor ó
Igual que
>=
Mayor ó
Igual que
=
Igual que
BETWEEN
Utilizado
para especificar un intervalo de valores.
LIKE
Utilizado
en la comparación de un modelo
IN
Utilizado
para especificar registros de una base de datos
FUNCIONES
DE AGREGADO
Estas funciones
se usan dentro de una cláusula SELECT en grupos de registros para devolver un
único valor que se aplica al grupo de registros a los que se refiere.
Función
Descripción
AVG
Calcula
el promedio de los valores de un campo determinado
COUNT
Devuelve
el número de registros de la selección
SUM
Suma de
todos los valores de un campo determinado
MAX
Devuelve
el valor más alto de un campo especificado
MIN
Devuelve
el valor más bajo de un campo especificado

PREDICADO
El predicado,
sirve para se debe incluir o debe ir entre la cláusula y el primer nombre del
campo del cual se desean recuperar los datos, a final del tutorial  en el título
Subconsultas, se usan, los predicados ANY y SOME, entre los predicados aparte
de los mencionados, tenemos:
  
Predicado
Descripción
ALL
Devuelve
todos los campos de la tabla
TOP
Devuelve
un determinado número de registros de la tabla
ANY
Hace
referencia a alguno de los registros de la tabla
SOME
Hace
referencia a alguno de los registros de la tabla
DISTINCT
Omite los
registros cuyos campos seleccionados coincidan totalmente
DISTINCTROW
Omite los
registros duplicados basándose en la totalidad
del registro y no sólo en los campos seleccionados.



OPERADOR LIKE
Este operador se usa para comparar una expresión de cadena con un modelo en una expresión SQL, tipos de coincidencia.

Tipo de coincidencia
Modelo Planteado
Coincide
No coincide
Varios caracteres
‘a*a’
‘aa’, ‘aBa’, ‘aBBBa’
‘aBC’
Carácter especial
‘a[*]a’
‘a*a’
‘aaa’
Varios caracteres
‘ab*’
‘abcdefg’, ‘abc’
‘cab’, ‘aab’
Un solo carácter
‘a?a’
‘aaa’, ‘a3a’, ‘aBa’
‘aBBBa’
Un solo dígito
‘a#a’
‘a0a’, ‘a1a’, ‘a2a’
‘aaa’, ‘a10a’
Rango de caracteres
‘[a-z]’
‘f’, ‘p’, ‘j’
‘2’, ‘&’
Fuera de un rango
‘[!a-z]’
‘9’, ‘&’, ‘%’
‘b’, ‘a’
Distinto de un dígito
‘[!0-9]’
‘A’, ‘a’, ‘&’, ‘~’
‘0’, ‘1’, ‘9’
Combinada
‘a[!b-m]#’
‘An9’, ‘az0’, ‘a99’
‘abc’, ‘aj0’





TIPO DE
DATOS

Los tipos de datos
que se manejan con SQL son trece tipos denominados primarios y varios sinónimos
que son reconocidos por dichos tipos de datos, en el cuadro que sigue se
exponen los datos primarios y en el que sigue los sinónimos que reconoce.
Tipo de Datos
Longitud
Descripción
BINARY
1 byte
Para consultas sobre
tabla adjunta de productos de bases de datos que definen un tipo de datos
Binario.
BIT
1 byte
Valores Si/No ó
True/False
BYTE
1 byte
Un valor entero entre
0 y 255.
COUNTER
4 bytes
Un número
incrementado automáticamente (de tipo Long)
CURRENCY
8 bytes
Un entero escalable
entre 922.337.203.685.477,5808 y 922.337.203.685.477,5807.
DATETIME
8 bytes
Un valor de fecha u
hora entre los años 100 y 9999.
SINGLE
4 bytes
Un valor en punto
flotante de precisión simple con un rango de -3.402823*1038 a -1.401298*10-45
para valores negativos, 1.401298*10-45 a 3.402823*1038 para valores
positivos, y 0.
DOUBLE
8 bytes
Un valor en punto
flotante de doble precisión con un rango de -1.79769313486232*10308 a
-4.94065645841247*10-324 para valores negativos, 4.94065645841247*10-324 a
1.79769313486232*10308 para valores positivos, y 0.
SHORT
2 bytes
Un entero corto entre
-32,768 y 32,767.
LONG
4 bytes
Un entero largo entre
-2,147,483,648 y 2,147,483,647.
LONGTEXT
1 byte por carácter
De cero a un máximo
de 1.2 gigabytes.
LONGBINARY
Según se necesite
De cero 1 gigabyte.
Utilizado para objetos OLE.
TEXT
1 byte por caracter
De cero a 255
caracteres.
La tabla muestra los
tipos de datos sinónimos:
Tipo de
Dato
Sinónimos
BINARY
VARBINARY
BIT
BOOLEAN
LOGICAL
LOGICAL1
YESNO
BYTE
INTEGER1
COUNTER
AUTOINCREMENT
CURRENCY
MONEY
DATETIME
DATE
TIME
TIMESTAMP
SINGLE
FLOAT4
IEEESINGLE
REAL
DOUBLE
FLOAT
FLOAT8
IEEEDOUBLE
NUMBER
NUMERIC
SHORT
INTEGER2
SMALLINT
LONG
INT
INTEGER
INTEGER4
LONGBINARY
GENERAL
OLEOBJECT
LONGTEXT
LONGCHAR
MEMO
NOTE
TEXT
ALPHANUMERIC
CHAR
CHARACTER
STRING
VARCHAR
VARIANT
(No Admitido)
VALUE
CLÁUSULA
FROM
Esta cláusula no
tiene mayores análisis, determina en que tabla se buscarán o harán las distintas
operaciones.

El siguiente ejemplo permite seleccionar todos los campos de la tabla Ventas.
SELECT * FROM
Ventas

Esta sentencia SQL selecciona el campo Cliente de la tabla Ventas
SELECT Cliente FROM Ventas
CLÁUSULA WHERE
Esta cláusula se
ha visto a lo largo de los ejemplos que acá se han expuesto, permite determinar
que registros se van a filtrar o recuperar; en otras palabras, determina que
registros de la tabla seleccionada con la cláusula FROM deberán aparecer o
serán el resultado de la instrucción SELECT.
Esta cláusula es
opcional, si no se utiliza la instrucción SELECT devolverá todos los registros
de los campos especificados algunos ejemplos aclararán el panorama.
Selecciona todos
los campos cuyos registros del campo cliente sean igual a Dayra Col y Tomy Lee.
SELECT * FROM Ventas WHERE Cliente = ‘Dayra Col’
OR  Cliente = ‘Tomy Lee’
Selecciona el
campo cliente de la tabla ventas cuando venta sea superior a 450000
SELECT Cliente FROM Ventas WHERE Venta > 450000
Selecciona todos
los campos cuando los registros del campo cliente se encuentren entre Day y
Tom.
SELECT * FROM Ventas WHERE Cliente BETWEEN ‘Day’
AND ‘Tom’
CLÁUSULA
GROUP BY
La cláusula GROUP
BY o agrupamiento de registros combina o une registros con valores idénticos en
una lista de campos especificados, en un solo
registro, obteniéndose una sumatoria si se incluyen en la
sentencia SQL funciones de agregado como sumar o contar; la sintaxis de la
cláusula es:
SELECT Campo FROM
Tabla WHERE criterio GROUP BY campos del grupo.
La cláusula GROUP
BY no es obligatoria, si no existe una función SQL agregada en la instrucción,
los valores resúmenes se omiten; los valores nulos son agrupados por GROUP BY,
pero no se evalúan en las funciones SQL agregadas; se puede
agrupar cualquier campo de la tabla indicada por la cláusula FROM, excepto
campos tipo memo y objetos OLE.
Al usar la
cláusula WHERE se filtran los datos que se requieren agrupar; también se puede
usar la cláusula HAVING para filtrar registros una vez agrupados los datos con
GROUP BY.
Los campos de la
lista GROUP BY puede referirse a cualquier campo de la tabla FROM, incluso si
el campo no está incluido en la instrucción SELECT siempre y cuando SELECT
contenga una función SQL agregada.
El siguiente
ejemplo despejará algunas dudas; la sentencia SQL solicita seleccionar los
datos del campo Fecha y Cliente, sumando el campo Venta de la tabla Ventas,
cuando su estado sea finalizado, agrupando las ventas por fecha.
SELECT Fecha,
Cliente, Estado SUM (Venta) FROM Ventas  WHERE Estado=
‘Finalizado’ GROUP BY Fecha
CLÁUSULA
HAVING
 
La cláusula
HAVING es similar a la cláusula WHERE, la diferencia reside en que permite
filtrar datos ya agrupados por la cláusula GROUP BY, es decir muestra los
registros ya agrupados y que cumplan los criterios establecidos en la cláusula
HAVING.
La siguiente
sentencia SQL expresa que se deben mostrar los campos Fecha, Cliente y sumar
(Venta) de la tabla Ventas, cuando su estado sea finalizado, agrupando datos
por Fecha, una vez agrupados mostrar las ventas superiores a 60000 de los
clientes Dayra Col y Tomy Lee.
SELECT Fecha,
Cliente, Estado, SUM (Venta) FROM Ventas WHERE Estado=
‘Finalizado’ GROUP BY Fecha HAVING SUM (Venta) >600000 AND Cliente =
‘Dayra Col’ OR Cliente = ‘Tomy Lee’
CLÁUSULA
ORDER BY
Cuando se realiza
una consulta muchas veces se necesita ordenar registros y especificar el orden
en que se requiere sean devuelto los datos de las distintas tablas ello es
posible con la cláusula ORDER BY, siguiendo el ejemplo anterior si se requiere
que los datos sean devueltos ordenados por Cliente y luego por fecha, la
consulta SQL sería la siguiente: 
SELECT Fecha,
Cliente, Estado, SUM (Venta) FROM Ventas WHERE Estado=
‘Finalizado’ GROUP BY Fecha HAVING SUM (Venta) >600000 AND Cliente =
‘Dayra Col’ OR Cliente = ‘Tomy Lee’ ORDER BY Cliente, Fecha
Si se observa la
sentencia SQL anterior se ordena por más de un campos, los campos deben ir
separados por coma (,); se puede especificar el orden que se requieres es decir
Ascendente o Descendente, siempre el orden por defecto es Ascendente; la
cláusula del ejemplo quedaría así, en caso que quisiéramos ordenar Cliente en
forma Descendente y Fecha en forma Ascendente:
SELECT Fecha,
Cliente, Estado, SUM (Venta) FROM Ventas WHERE Estado=
‘Finalizado’ GROUP BY Fecha HAVING SUM (Venta) >600000 AND Cliente =
‘Dayra Col’ OR Cliente = ‘Tomy Lee’ ORDER BY Cliente DESC, Fecha ASC
Otro ejemplo
menos complicado donde solo se solicita ordenar se muestra a continuación:

SELECT Fecha, Cliente, Estado, Venta FROM Ventas  ORDER BY Cliente
SELECT Fecha, Cliente, Estado, Venta FROM Ventas  ORDER
BY Cliente DESC
SELECT Fecha,
Cliente, Estado, Venta FROM Ventas  ORDER BY Cliente DESC, Fecha
ASC

Continua en parte I Principales sentencias SQL

Continua en parte II Seleccionar Datos Comando SELECT

Continua en parte III Insertar, actualizar y eliminar Datos Comando INSERT, UPDATE DELETE

Si te fue de utilidad puedes INVITARME UN CAFÉ y de esta manera ayudar a seguir manteniendo la página, CLICK para descargar en ejemplo en forma gratuita.

(adsbygoogle = window.adsbygoogle || []).push({});

If this post was helpful INVITE ME A COFFEE and so help keep up the page, CLICK to download free example.
Si te gustó por favor compártelo con tus amigos
If you liked please share it with your friends      

Entradas relacionadas

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

Comentarios (135)

I am the owner of JustCBD label (justcbdstore.com) and I am currently seeking to broaden my wholesale side of business. I am hoping anybody at targetdomain share some guidance . I considered that the very best way to do this would be to reach out to vape companies and cbd retailers. I was really hoping if someone could suggest a qualified site where I can purchase CBD Shops B2B Database I am currently looking at creativebeartech.com, theeliquidboutique.co.uk and wowitloveithaveit.com. On the fence which one would be the very best option and would appreciate any assistance on this. Or would it be much simpler for me to scrape my own leads? Suggestions?

Responder

ответственность учредителя ооо читайте ответы юристов субсидиарная ответственность

Responder

Good post. I definitely love this website. Continue the good work!

Responder

Oh my goodness! Incredible article dude! Thanks, However I am going through issues with your RSS. I don’t know why I cannot join it. Is there anyone else getting the same RSS problems? Anyone that knows the solution can you kindly respond? Thanks!!

Responder

Hello, There’s no doubt that your website may be having internet browser compatibility issues. When I look at your web site in Safari, it looks fine however, if opening in I.E., it has some overlapping issues. I merely wanted to provide you with a quick heads up! Other than that, wonderful website!

Responder

Hi there, I do believe your website might be having web browser compatibility issues. Whenever I look at your website in Safari, it looks fine however, when opening in Internet Explorer, it has some overlapping issues. I simply wanted to provide you with a quick heads up! Besides that, wonderful website!

Responder

Your style is unique in comparison to other folks I’ve read stuff from. Thanks for posting when you’ve got the opportunity, Guess I will just bookmark this page.

Responder

Good post. I learn something totally new and challenging on websites I stumbleupon on a daily basis. It’s always helpful to read through content from other writers and use a little something from their websites.

Responder

I blog often and I seriously thank you for your information. This great article has really peaked my interest. I will take a note of your website and keep checking for new information about once a week. I subscribed to your RSS feed as well.

Responder

Aw, this was a really nice post. Taking the time and actual effort to produce a good article… but what can I say… I procrastinate a whole lot and don’t seem to get nearly anything done.

Responder

Your style is so unique in comparison to other people I’ve read stuff from. Many thanks for posting when you have the opportunity, Guess I will just book mark this site.

Responder

Your style is unique in comparison to other folks I’ve read stuff from. Thanks for posting when you’ve got the opportunity, Guess I’ll just book mark this site.

Responder

May I just say what a comfort to uncover someone who genuinely knows what they’re talking about over the internet. You definitely understand how to bring an issue to light and make it important. More and more people must look at this and understand this side of your story. I was surprised that you’re not more popular because you certainly possess the gift.

Responder

Aw, this was a really nice post. Taking the time and actual effort to generate a great article… but what can I say… I procrastinate a lot and don’t manage to get nearly anything done.

Responder

Great information. Lucky me I came across your website by chance (stumbleupon). I have saved it for later!

Responder

Very good information. Lucky me I recently found your blog by chance (stumbleupon). I’ve book marked it for later!

Responder

Right here is the right blog for anybody who really wants to understand this topic. You realize a whole lot its almost hard to argue with you (not that I actually would want to…HaHa). You certainly put a brand new spin on a subject that has been written about for a long time. Wonderful stuff, just wonderful!

Responder

Everyone loves it when folks come together and share views. Great site, continue the good work!

Responder

After looking into a number of the blog posts on your site, I seriously like your technique of blogging. I added it to my bookmark site list and will be checking back soon. Please visit my website too and let me know your opinion.

Responder

There’s definately a great deal to find out about this topic. I really like all of the points you’ve made.

Responder

Spot on with this write-up, I really believe this amazing site needs much more attention. I’ll probably be returning to read more, thanks for the information!

Responder

Greetings! Very helpful advice in this particular article! It is the little changes that make the biggest changes. Thanks a lot for sharing!

Responder

When I initially left a comment I seem to have clicked on the -Notify me when new comments are added- checkbox and now every time a comment is added I receive four emails with the exact same comment. Perhaps there is a way you are able to remove me from that service? Thanks!

Responder

Great information. Lucky me I ran across your site by chance (stumbleupon). I’ve saved it for later!

Responder

There’s definately a great deal to know about this subject. I like all the points you have made.

Responder

There’s definately a great deal to know about this subject. I like all the points you’ve made.

Responder

I am sure this post has touched all the internet
users, its really really fastidious article on building up new
blog. adreamoftrains best website hosting

Responder

It’s very straightforward to find out any matter on net as compared to books, as I found
this piece of writing at this web site.

Responder

May I simply say what a comfort to discover somebody that genuinely knows what they’re discussing on the net. You actually understand how to bring a problem to light and make it important. More people must check this out and understand this side of the story. It’s surprising you are not more popular because you definitely possess the gift.

Responder

I simply want to say I am just new to blogs and definitely enjoyed you’re blog site. More than likely I’m going to bookmark your blog . You amazingly have amazing articles and reviews. Thank you for sharing your website page.

Responder

Having read this I thought it was extremely enlightening. I appreciate you taking the time and energy to put this informative article together. I once again find myself personally spending a significant amount of time both reading and commenting. But so what, it was still worth it!

Responder

You made some good points there. I looked on the web for additional information about the issue and found most individuals will go along with your views on this web site.

Responder

Pretty! This was an extremely wonderful article. Thanks for providing this info.

Responder

I simply want to tell you that I am just new to weblog and definitely liked you’re blog. More than likely I’m going to bookmark your website . You certainly have terrific articles. Many thanks for sharing with us your website.

Responder

You’re so interesting! I don’t believe I’ve read something like this before. So good to discover somebody with a few genuine thoughts on this subject matter. Really.. thanks for starting this up. This web site is something that is needed on the internet, someone with a bit of originality!

Responder

May I simply say what a relief to discover someone who truly knows what they are discussing online. You actually understand how to bring an issue to light and make it important. More people need to check this out and understand this side of your story. It’s surprising you aren’t more popular since you definitely possess the gift.

Responder

Good post. I learn something totally new and challenging on sites I stumbleupon everyday. It’s always exciting to read through articles from other authors and use a little something from their web sites.

Responder

Having read this I thought it was rather enlightening. I appreciate you taking the time and energy to put this article together. I once again find myself spending way too much time both reading and leaving comments. But so what, it was still worth it!

Responder

You need to be a part of a contest for one of the most useful websites on the net. I am going to recommend this site!

Responder

I just want to mention I am just all new to blogging and site-building and truly loved this web-site. Almost certainly I’m going to bookmark your site . You absolutely have fabulous writings. Regards for sharing with us your blog.

Responder

I used to be able to find good advice from your blog posts.

Responder

Hello there! This blog post couldn’t be written any better! Looking through this article reminds me of my previous roommate! He always kept talking about this. I’ll forward this post to him. Pretty sure he will have a very good read. Thanks for sharing!

Responder

Aw, this was an exceptionally nice post. Taking a few minutes and actual effort to generate a great article… but what can I say… I hesitate a lot and don’t seem to get anything done.

Responder

I’m excited to find this web site. I wanted to thank you for ones time due to this wonderful read!! I definitely appreciated every little bit of it and I have you saved to fav to check out new stuff in your blog.

Responder

Good article. I will be going through many of these issues as well..

Responder

Way cool! Some very valid points! I appreciate you penning this article and the rest of the site is extremely good.

Responder

You’ve made some really good points there. I looked on the web for additional information about the issue and found most people will go along with your views on this web site.

Responder

You’ve made some really good points there. I looked on the internet for more info about the issue and found most people will go along with your views on this web site.

Responder

I’m amazed, I have to admit. Rarely do I encounter a blog that’s equally educative and amusing, and without a doubt, you’ve hit the nail on the head. The issue is an issue that too few men and women are speaking intelligently about. Now i’m very happy I came across this in my search for something relating to this.

Responder

I’m amazed, I have to admit. Seldom do I encounter a blog that’s both equally educative and entertaining, and let me tell you, you have hit the nail on the head. The problem is something not enough people are speaking intelligently about. I’m very happy that I stumbled across this during my search for something relating to this.

Responder

Can I simply say what a relief to uncover an individual who truly knows what they are talking about on the net. You definitely know how to bring an issue to light and make it important. A lot more people must look at this and understand this side of your story. It’s surprising you’re not more popular given that you certainly have the gift.

Responder

After I originally left a comment I seem to have clicked the -Notify me when new comments are added- checkbox and now whenever a comment is added I receive 4 emails with the same comment. Is there an easy method you can remove me from that service? Kudos!

Responder

I’m amazed, I must say. Rarely do I come across a blog that’s equally educative and entertaining, and without a doubt, you have hit the nail on the head. The problem is something too few folks are speaking intelligently about. I am very happy that I came across this in my search for something concerning this.

Responder

This website is really a walk-through for all of the details you desired regarding this and didn?t know who to ask. Glance right here, as well as you?ll absolutely discover it.

Responder

I absolutely love your website.. Excellent colors & theme. Did you create this amazing site yourself? Please reply back as I’m trying to create my own personal blog and would like to find out where you got this from or just what the theme is named. Cheers!|

Responder

pitkävetovihjeet

Responder

It’s remarkable to visit this site and reading the views of all
friends about this paragraph, while I am also eager of getting experience.

Responder

KAISERSLUST Plattform der Wiener Sex Scene Sex in Wien – Girls in Wien – Escorte Wien – Transen Wien – Hostessen Wien Escort Wien – Massagen Wien – Studios Wien – Laufhaus und Bordelle Wien Asiatinnen Wien – Sex in Wien – Kaiserslust – Der Kaiser hat Lust – Sex

Responder

“an impresario of expressionism”

Responder

Shop; Unique Functions. Simple Product Layouts. Post with review. Advanced Product Layout. Best conversion pages. Frontend Search · Listing example …

Responder

Hello, I enjoy reading through your post. I like to write a little comment to support you.|

Responder

netticasinot pikakasinot parhaat netticasinot

Responder

What’s up friends, nice piece of writing and pleasant urging commented at this place, I
am actually enjoying by these. 2CSYEon cheap flights

Responder

Welcome to iBeautys Best, iBeautys Best is the number one destination for Latest Beauty Products. Here you can easily buy your desired product from all over the world with very reasonable price.

Responder

My developer is trying to convince me to move to .net from PHP. I have always disliked the idea because of the expenses. But he’s tryiong none the less. I’ve been using Movable-type on a number of websites for about a year and am nervous about switching to another platform. I have heard great things about blogengine.net. Is there a way I can transfer all my wordpress content into it? Any kind of help would be really appreciated!|

Responder

Ahaa, its good dialogue concerning this paragraph here at this web site, I have read all that, so now me also commenting here.|

Responder

Hi there, I desire to subscribe for this website to get most recent updates, therefore where can i do it please assist.

Responder

Hi every one, here every one is sharing these know-how, thus it’s good to read this website, and I used to visit this webpage everyday.

Responder

David-Home Northeast is your premier source for all of your Real Estate investing needs. We provide a variety of solutions for sellers looking to sell fast and investors looking to grow their real estate investment portfolios for better returns. At David-Home Northeast, we are dedicated to improving and redeveloping the areas that we operate in. We specialize in helping sellers of distressed properties (single and multi-family homes, commercial, retail, bank REOs, etc.) find buyers looking to invest. Let us put our network of cash home buyers and private money lenders to work for you so you can say “David” to that old unwanted property.

Responder

Now I am ready to do my breakfast, afterward having my breakfast coming yet again to read more news.|

Responder

Do you mind if I quote a few of your articles as long as I provide credit and sources back to
your site? My website is in the exact same area of interest as yours and my users would certainly benefit from some of the information you provide here.
Please let me know if this alright with you.

Appreciate it!

Responder

Excel y SQL principales sentencias – PROGRAMAR EN VBA MACROS DE EXCEL
amzcqvbgpxp
[url=http://www.g12quk6p9i920x3dth3k3jq1a9q571k4s.org/]umzcqvbgpxp[/url]
mzcqvbgpxp http://www.g12quk6p9i920x3dth3k3jq1a9q571k4s.org/

Responder

How does Ibogaine cure addiction

Responder

Natural Releaf CBD | New York CBD Store with locations in Murray Hill, NY | Upper East Side, NY | White Plains, NY Serving New York City, NY and Westchester, NY High Quality CBD Products With Lab Test

Responder

Love watching sunset !

Responder

Love watching sunset !

Responder

Wonderful work! This is the kind of information that are meant to be shared across the internet. Shame on Google for now not positioning this post higher! Come on over and discuss with my web site . Thank you =)|

Responder

ilmaiset pornovideot, pornovideot, porno videot, pornovideoita, porn videos, free pornvideos, porno video

Responder

investors

Responder

Love watching sunset !

Responder

Hi, i think that i saw you visited my weblog thus i came to ìreturn the favorî.I’m attempting to find things to improve my website!I suppose its ok to use some of your ideas!!|

Responder

Best view i have ever seen !

Responder

Love watching sunset !

Responder

ilmaiset videot, ilmaiset pornovideot, ilmaiset porno videot, porno video, porno videot

Responder

I’m really inspired along with your writing skillsand also with the structure to your blog. Is this a paid subject or did you customize ityourself? Either way keep up the nice quality writing, it’s uncommon to see a nice weblog like this one today..

Responder

Somebody essentially lend a hand to make significantly posts I’d state. That is the first time I frequented your web page and thus far? I amazed with the research you made to create this particular submit incredible. Wonderful activity!

Responder

Temperature Scanning

Responder

Hmm is anyone else encountering problems with the
pictures on this blog loading? I’m trying to find out if its a problem
on my end or if it’s the blog. Any suggestions would
be greatly appreciated.

Responder

I have been browsing online more than 3 hours today, yet I never found any interesting article like yours. It is pretty worth enough for me. In my view, if all site owners and bloggers made good content as you did, the internet will be much more useful than ever before.|

Responder

We are building consultants. We perform roof assessments, window testing, and wall testing for quality assurance on new and existing buildings.

Responder

Online jewelry boutique specializing in custom gold and silver pieces. For the hippy hearted fashion lover. Known for its custom lotus flower hoop earrings and large collection of hoop earrings. Customers enjoy the classic and unique versatile everyday jewelry designs. Glamour hippy began is also known for its dainty gold jewelry pieces. Bohemian chic styles with modern fashion flare. Great prices and affordable. Everyday pieces to statement piece designs for special occasions. Glamour hippy is inspired by diverse world culture and it reflects into the ever changing designs. Its customer enjoys unique pieces and comfort in style. Glamour hippy wants to be a part of its customers wardrobe for many years and part of great memories where ever the customer takes their jewelry pieces. Glamour hippy is glamour and hippy all in one. Shiny pretty pieces, Unique, Glamorous, boho chic, one of a kind, dainty, but statement worthy.

Responder

netticasinot, netticasino, casino, kasinot, nettkasinot

Responder

I truly love your website.. Pleasant colors & theme. Did you build this amazing site yourself? Please reply back as I’m hoping to create my own site and would love to find out where you got this from or what the theme is called. Thanks!|

Responder

I really like your writing style, excellent info , appreciate it for putting up : D.

Responder

GEM-CAR auto repair shop management software is arguably the most comprehensive software of its kind currently available. Lauded for its easy to use modules including CRM, digital inspection and electronic punch clock: it provides the repair shop operator with a complete system to run the business. GEM-CAR puts the shop operator firmly in the driver’s seat. And if you are a fleet operator look for GEM-FLEET our fleet management software.

Responder

I’m impressed, I need to say. Really not often do I encounter a weblog that’s each educative and entertaining, and let me tell you, you’ve gotten hit the nail on the head. Your idea is excellent; the problem is one thing that not enough individuals are talking intelligently about. I’m very pleased that I stumbled across this in my seek for one thing regarding this.

Responder

Thanks , I have just been searching for information about this subject for ages and yours is the best I’ve discovered till now. But, what about the conclusion? Are you sure about the source?

Responder

You are a very smart person!

Responder

Thanks, I’ve just been searching for information about this topic for a while and yours is the greatest I’ve found out till now. However, what about the bottom line? Are you certain in regards to the source?

Responder

Definitely, what a splendid blog and revealing posts, I surely will bookmark your site.Have an awsome day!

Responder

Thanks for a marvelous posting! I really enjoyed reading it, you may be a great author.I will ensure that I bookmark your blog and will come back sometime soon. I want to encourage you to ultimately continue your great writing, have a nice weekend!

Responder

You made some excellent points there. I checked on the web
for additional information regarding the issue and located a lot of people will go as well as your views on this web site.

Review my website … ElzaRLingley

Responder

Thank you for the good writeup. It in fact was a amusement account it. Look advanced to more added agreeable from you! By the way, how could we communicate?

Responder

Find The Top Rated Web Hosting

Responder

… [Trackback]

[…] Informations on that Topic: macrosenexcel.com/excel-y-sql-principales-sentencias/ […]

Responder

la hookup

Responder

Hello, you used to write wonderful, but the last few posts have been kinda boring… I miss your tremendous writings. Past several posts are just a little out of track! come on!

Responder

Excellent site. A lot of helpful information here. I am sending it to several pals ans additionally sharing in delicious. And of course, thanks on your effort!

Responder

This is a topic which is close to my heart… Cheers! Exactly where are your contact details though?

Responder

Our Mushroomburger The signature Mushroomburger patty was created back in 1979. Still to everyone’s surprise, it is approximately made up of 50 mushrooms and 50 real beef.

Responder

What i do not realize is actually how you’re not actually much more well-liked than you may be right now. You are so intelligent. You realize thus significantly relating to this subject, produced me personally consider it from numerous varied angles. Its like men and women aren’t fascinated unless it’s one thing to do with Lady gaga! Your own stuffs great. Always maintain it up!

Responder

I like it when folks come together and share thoughts. Great site, stick with it!

Responder

book hotels, find hotels, discount hotels, hotel deals, compare hotels, search for hotels, best hotels, hotel deals, hotel packages, city packages

Responder

That is very interesting, You’re an overly skilled blogger.
I’ve joined your rss feed and sit up for in quest of extra
of your wonderful post. Also, I’ve shared your web site in my social
networks

Responder

Pretty! This has been a really wonderful article. Many thanks for providing these details.

Responder

Oh my goodness! Amazing article dude! Thanks, However I am going through problems with your RSS. I don’t know why I can’t subscribe to it. Is there anybody else getting similar RSS issues? Anyone that knows the solution will you kindly respond? Thanx!!

Responder

Site Rank Services offers affordable premium SEO packages & helps increase the visibility of your site in the search engines. We help you generate more profits

Responder

Awesome issues here. I am very glad to look your post.
Thank you so much and I’m taking a look ahead to touch you.

Will you please drop me a mail?

Responder

Today, I went to the beach with my kids. I found a sea shell and gave it to my 4 year old daughter and said «You can hear the ocean if you put this to your ear.» She put the shell to her ear and screamed. There was a hermit crab inside and it pinched her ear. She never wants to go back! LoL I know this is completely off topic but I had to tell someone!

Responder

Hello! I just would like to give you a big thumbs up for the excellent info you have here on this post. I will be returning to your website for more soon.

Responder

Your style is unique in comparison to other people I’ve read stuff from. Many thanks for posting when you’ve got the opportunity, Guess I’ll just bookmark this page.

Responder

Way cool! Some extremely valid points! I appreciate you writing this post and also the rest of the site is also really good.

Responder

Shopify fitness store

Responder

Hi there, I found your web site via Google while searching for a related topic, your website came up, it looks great. I’ve bookmarked it in my google bookmarks.

Responder

I am not sure where you’re getting your information, but great topic. I needs to spend some time learning more or understanding more. Thanks for excellent information I was looking for this information for my mission.

Responder

Can I just say what a comfort to uncover someone that truly knows what they’re talking about over the internet. You certainly know how to bring a problem to light and make it important. More people ought to read this and understand this side of your story. I was surprised that you are not more popular because you most certainly possess the gift.

Responder