Table Logic

  • Thread starter Thread starter Mxinter
  • Start date Start date
M

Mxinter

Hi Guys,

I have a question.

I have a table with 5 columns and approximately 20,000
lines of data. I know that this will be much simpler to do
it in access but not alot of the people have access in my
company and may not know how to use it..therefore excel is
the way to go. Column "A" represent a location ID,
Column "B" Supplier Name, Column "C" Supplier Country
(only 6 countries right now) . What I want to do is an
application, so that when I tell the user to select a
location ID ("A") from a Dropdown menu....it returns each
of the 6 countries ("C") with their respective supplier
("B") name. I need to build the logic that permitts me to
do this....can you guys help me with the logic and/or
function to do this.....

Thx for your help

mxinter
 
Thx Frank for the quick response.

This isnt really what I'm looking for....I want to have
all the output in the excel sheet instead of on the
dropdown menu. For instance, with that example..if user
selects "fruits" I want excel to autopopulate all the
fruits in a column...and not as part of another
conditional dropdown.....from my example below...I want to
select say "XYZ" and then I would have 6 columns
representing each country....and I want to autopopulate
the suppliers name "colum B" under each country......I
know the dropdown stuff...but what I dont know is how to
assign a function to each of the 6 column...for the data
to autopopulate..... Please help anyone?

mxinter
 
Mxinter said:
I have a table with 5 columns and approximately 20,000
lines of data. I know that this will be much simpler to do
it in access but not alot of the people have access in my
company and may not know how to use it..therefore excel is
the way to go.
Click to expand...

Abolsutely, but why not have the best of both worlds and use Jet (MS
Access) for the backend database and Excel as the front end, using ADO
to communicate between the both?

Standard answer number 3... You don't need the MS Access application
to create and/or query a Jet database (.mdb file). You can do all this
on the fly using only Excel and ADOX (to create the .mdb file) and ADO
(use DDL statements to create the schema e.g. CREATE TABLE etc and SQL
for queries).

You do need MDAC, free MS download and shipped with Excel, and Jet,
free MS download and shipped with early versions of MDAC, so it's
highly likely you already have the necessary components shipped with
Excel.

See the following links (in these articles, read 'Jet' for the word
'Access'
because the MS Access application is not actually used):

Creating an Access(sic) Database:
http://msdn.microsoft.com/library/d...s/odeopg/html/deovrcreatingaccessdatabase.asp

Running a Temporary Query:
http://msdn.microsoft.com/library/d...s/odeopg/html/deovrcreatingaccessdatabase.asp

--
 
Back
Top