Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calling access data from excel
I have an access db with columns for example "name", "surname", "date of
birth" and "place of birth". And I have an empty worksheet in excel with the same columns: column1 = id number column2 = name column3 = surname column4 = date of birth column5 = place of birth Now, is it possible to call the data by some type of "id" or something that for example when i enter "3" in excel sheet column1, it will automatically fill the other columns by taking data from my access db (person numbered 3 in access db) ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exporting data in Excel permanently to Access | Links and Linking in Excel | |||
Data from Excel to Access Table | Excel Discussion (Misc queries) | |||
How to import data from a password protected Access DB into Excel. | Excel Discussion (Misc queries) | |||
New Excel data does not appear in linked Access table | Excel Discussion (Misc queries) | |||
MS Excel data reading in MS Access | Excel Discussion (Misc queries) |