Retrieving information from database and placing in other worksheet

**jgcramer** · 05-16-2013, 11:12 PM

First off just wanted to say thanks for all the help, When I got this project, I had not done any work with VBA, macros, and with your guys help I have learned quite a bit in last week. The current setup of this project have the summary sheets refer to the database to get the pertinent data using the sumif function which is pretty straight forward. what i need to be able to do is to retrieve the customers name and when it meets certain criteria like date ordered, model. I am really not sure how to approach this, I am not asking you to write the code but how would you approach doing this or where can i go to learn how to do it, thanks for the help.
data retrival.xlsm

**RamVador** · 05-16-2013, 11:49 PM

Hi jgcramer,

If you are interested in progressing in the powerful field of extracting data from databases from excel that is a great decision. First you need to learn the basics of extracting data: sql language, which is universal for all databases in the market with little differences only in the advanced commands.
I had a look at your spreadsheet and the layout is not quite for what you are describing. I suggest that you start by listing the fields and conditions that you need to meet and then: a) determine how you are going to connect to the database you want to extract the data from. b) identify Server and login required to establish connection (you may need some IT support person to help you). c)write a Select query with the conditions required (www.3schools.com for tutorials) d) use the "Get external data" from other sources and use the help to guide your steps

You will need to put some time on it but the results are worth. Hope I gave you some help, Good luck!