Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookups in Excel on Data from Access not working
I have several excel files that have the same information in them. This same
information is in an access database. Instead of changing all my files when something changes I am setting it up to link them all so it will update itself. I have exported the data from the access database into my excel file that is doing several lookups on tables I have in these files, so that I can calculate information needed for my reports. So far I can get it to export the data from Access to my excel file with a query, but once it is in excel my lookups don't recognize the data and give me #NA & #REF!. I need to find out why it is doing this and how to get it to recognize the information I am pulling in. Any ideas how to do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Matching Button for MS Excel 2007 or later | Excel Worksheet Functions | |||
how do I format data from access to work in excel calculations? | Excel Worksheet Functions | |||
calling access data from excel | Excel Discussion (Misc queries) | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
data transfer from Excel to Access but the new table stru is diff | Excel Discussion (Misc queries) |