Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pulling data out of a large database
I am trying to build a file to pull information from a larger database and
put it into summary file. I would like to be able to use criteria like 15 months and % range <100 to pull information about products from a larger database. A single row of data would have multiple columns. I need to be able to pull the entire row of data, that corresponds to the criteria, to the summary sheet. I hope this makes sense. Thanks |
#2
|
|||
|
|||
Dave,
You need to make an ODBC connection to the database and use MSQuery to query the data. Click on Data, Import External Data, New Database Query. In the Choose data source select a preexisting data connection or create a new one to your database. Follow the wizard from there. "Dave" wrote: I am trying to build a file to pull information from a larger database and put it into summary file. I would like to be able to use criteria like 15 months and % range <100 to pull information about products from a larger database. A single row of data would have multiple columns. I need to be able to pull the entire row of data, that corresponds to the criteria, to the summary sheet. I hope this makes sense. Thanks |
#3
|
|||
|
|||
Hi Gary
Sorry, I did not include enough info. The data in the "database" is in an Excel file. Is there a way to query the excel file? Thanks "Gary Rowe" wrote: Dave, You need to make an ODBC connection to the database and use MSQuery to query the data. Click on Data, Import External Data, New Database Query. In the Choose data source select a preexisting data connection or create a new one to your database. Follow the wizard from there. "Dave" wrote: I am trying to build a file to pull information from a larger database and put it into summary file. I would like to be able to use criteria like 15 months and % range <100 to pull information about products from a larger database. A single row of data would have multiple columns. I need to be able to pull the entire row of data, that corresponds to the criteria, to the summary sheet. I hope this makes sense. Thanks |
#4
|
|||
|
|||
You can use an Advanced Filter to extract the data. There are
instructions in Excel's Help, and he http://www.contextures.com/xladvfilter01.html Dave wrote: I am trying to build a file to pull information from a larger database and put it into summary file. I would like to be able to use criteria like 15 months and % range <100 to pull information about products from a larger database. A single row of data would have multiple columns. I need to be able to pull the entire row of data, that corresponds to the criteria, to the summary sheet. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#5
|
|||
|
|||
Dave,
Yes you can query a worksheet including the workbook you're working in. Your data needs to be in a table with a header row for each column. Click on data, import external data, new database query. On the choose data source dialog box choose "excel files" and then select the excile file with the worksheet data you're wanting to query. Proceed from there. "Dave" wrote: Hi Gary Sorry, I did not include enough info. The data in the "database" is in an Excel file. Is there a way to query the excel file? Thanks "Gary Rowe" wrote: Dave, You need to make an ODBC connection to the database and use MSQuery to query the data. Click on Data, Import External Data, New Database Query. In the Choose data source select a preexisting data connection or create a new one to your database. Follow the wizard from there. "Dave" wrote: I am trying to build a file to pull information from a larger database and put it into summary file. I would like to be able to use criteria like 15 months and % range <100 to pull information about products from a larger database. A single row of data would have multiple columns. I need to be able to pull the entire row of data, that corresponds to the criteria, to the summary sheet. I hope this makes sense. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) |