shirkus
New Member
- Joined
- Aug 22, 2006
- Messages
- 7
I have an excel spreadsheet that uses vlookup to search area codes and return a value based on the time zone that the area code is in. I then use the information in an access database. I would like to do the lookup in access but I can't figure out how? Can I vlookup an excel spreadsheet from access? Is there a much easier way to do this?
I would have no problem moving the area code data from excel to an access table if that would make it easier.
Can someone help?
Thanks in Advance....
I would have no problem moving the area code data from excel to an access table if that would make it easier.
Can someone help?
Thanks in Advance....