Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mattolson01

    import 2-dimensional lookup table from Excel

    This is most definitely a naive approach--she's a rookie and I'm an Excel jockey. Mike, you ask the very question I am trying to discover the answer to. How _can_ you put this into Access in the original format? If you think about it, the Excel table depends on treating the column HEADERS as...
  2. mattolson01

    import 2-dimensional lookup table from Excel

    First off, the numbers are made up--this isn't actually about insurance, but another industry altogether. I just made up a 2-D lookup table to illustrate the idea. I didn't want to confuse the issue with all the other problems the real data has! The row: cust |minVal |maxVal |minWgt |maxWgt...
  3. mattolson01

    import 2-dimensional lookup table from Excel

    I'm sorry if this is answered elsewhere, I promise I looked! Maybe I don't know the right terminology to find it. -- I have a situation where someone regularly puts two-dimensional lookup tables into Access. If the table in Excel looks like this: "Customer 'bob' Insurance Table"...

Part and Inventory Search

Back
Top