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: *
- Users: mattolson01
- Order by date
-
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...- mattolson01
- Post #5
- Forum: Microsoft: Access Tables and Relationships
-
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...- mattolson01
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
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"...- mattolson01
- Thread
- Replies: 4
- Forum: Microsoft: Access Tables and Relationships
