KeyJamber
January 31st, 2003, 02:00 AM
The Problem:
I am having trouble trying to create a query in MSExcel 97. I have the correct drivers loaded, and when I use the "Query wizard" I end up getting to a point where I need to select which table I want the query to search...however it lists none.
To add to my confusion, there is really no "good" help on making a table so I am kind of stuck...
The Goal:
I have a worksheet called "product_data" that holds my records. There are 7 columns, each is labeled in row 1, and column A is the column I want to query and return results for.
I would like to initialize the query from another worksheet called "Interface" by pressing a button and then return the results to 7 cells on that same worksheet...
Any help for me guys? Please!?
KeyJamber
I am having trouble trying to create a query in MSExcel 97. I have the correct drivers loaded, and when I use the "Query wizard" I end up getting to a point where I need to select which table I want the query to search...however it lists none.
To add to my confusion, there is really no "good" help on making a table so I am kind of stuck...
The Goal:
I have a worksheet called "product_data" that holds my records. There are 7 columns, each is labeled in row 1, and column A is the column I want to query and return results for.
I would like to initialize the query from another worksheet called "Interface" by pressing a button and then return the results to 7 cells on that same worksheet...
Any help for me guys? Please!?
KeyJamber