Import data to specific cells for a specific row

[nettacox]

I have an Oracle table with multiple rows. I would like to import data from
this table into an Excel worksheet. There are two specific issue:
1) I would like to be prompted for a specific identifer to only bring in
one specific row (i.e vendor id)
2) I would like to only bring in specific data from this table and into
specific cells (i.e vendor name goes into cell C3 and vendor classifcation
goes into cell C10).

Is this possible and if so any recommendations on how to accomplish?

 

[SkipVought]

Hi,

1) you can do with a simple parameter query, that returns the data to a fixed location. Data > Import External Data > New Database Query... You must have an Oracle Driver configured in Start > control Panel > Administrative tools > Data sources ODBC... The parameter can be entered in a cell, triggering the query to execute. I'd use Data > Validation-LIST for that parameter cell, which would give the user a list of vendor codes to select from.

2) can be done with a user-defined function in VBA. Post this question in Forum707.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}