| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I a cell in Excel to a cell in Access?
I want to use a vlookup type function to access data in Access. I am unable to export the information to Excel because it is 180,000 rows. Example: If the data in cell A1 is a Social Security Number, I want to be able to access a name associated with this number in access. Is this possible? Thanks in advance for any comments. -- maacmaac ------------------------------------------------------------------------ maacmaac's Profile: http://www.excelforum.com/member.php...fo&userid=2959 View this thread: http://www.excelforum.com/showthread...hreadid=465784 |
|
#2
|
|||
|
|||
|
Using ADO and a UDF you could do it, like this for example:
http://mrexcel.com/board2/viewtopic....cess+vl ookup -- Regards, Juan Pablo González Excel MVP "maacmaac" wrote in message ... I want to use a vlookup type function to access data in Access. I am unable to export the information to Excel because it is 180,000 rows. Example: If the data in cell A1 is a Social Security Number, I want to be able to access a name associated with this number in access. Is this possible? Thanks in advance for any comments. -- maacmaac ------------------------------------------------------------------------ maacmaac's Profile: http://www.excelforum.com/member.php...fo&userid=2959 View this thread: http://www.excelforum.com/showthread...hreadid=465784 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) | |||
Linear Mode
