Thread: [Solved] Input data in Excel and get info from Access
View Single Post
 
Old 08-10-2014, 08:17 AM
zkibz zkibz is offline Windows 7 32bit Office 2007
Novice
  
Join Date: Aug 2014
Posts: 1
zkibz is on a distinguished road
Default Input data in Excel and get info from Access
Hi,

First of all, I'm not so familiar creating a big formula on MS Excel and even on MS Access.

I'm looking for a formula that when I enter value in MS Excel for example 12345, it gets the corresponding data from MS Access and it will display the result on the same MS Excel that I'm using. For example,

I entered in my Excel file, 49999 and it will display a result of National. And this data "National" stores on MS Access.

Can someone help me with this? I think this is not so hard to do for those who knows programming.
Reply With Quote