Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Query Excel database from desktop
I am looking to create a small desktop application that will query an excel
database to match the zip code provided by the user of desktop application. If the zip code matches, the database will provide back a result based on the column information directly to the right of the zip code in the database. Is this something that can be done just in excel, or what type of small application will allow us to access the database without actually having Excel opened or even on the computer. -- Lost |
#2
|
|||
|
|||
You could surely do this in excel using =vlookup(). But that means that the
user has to have excel and excel has to open (as well as that workbook). But depending on what you're looking for, you could save the data as a .CSV file and use an old DOS command: Windows start button|Run (or get to the command prompt): find "00012" "c:\my documents\excel\book1.csv" If you do this: find /? You'll see a short help for Find. =========== I would think if you could find someone who spoke VB (or any other standalone language), they could even make a nice little program with a pretty interface that you could use to display the results. Lost But Trying Hard wrote: I am looking to create a small desktop application that will query an excel database to match the zip code provided by the user of desktop application. If the zip code matches, the database will provide back a result based on the column information directly to the right of the zip code in the database. Is this something that can be done just in excel, or what type of small application will allow us to access the database without actually having Excel opened or even on the computer. -- Lost -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - New Database Query | Excel Discussion (Misc queries) | |||
Error message in Excel after exporting Access query to Excel | Excel Discussion (Misc queries) | |||
Excel Query Wizard Date Format | Excel Discussion (Misc queries) | |||
Import from Database using field from excel. | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |