Link to home
Start Free TrialLog in
Avatar of vmccune
vmccuneFlag for United States of America

asked on

Access / Excel Integration


I have a need to work between a new Access 2010 / 2013 database that is being built from an Excel spreadsheet.  I have multiple vlookups on the one I am converting to Access but I also have multiple other excel spreadsheets that were using the data in the old Excel sheet that I am converting to Access.  The project is large enough that I cannot do everything at once and so I am looking for some advice on the best way to keep everything up to date as real time as possible.

What is the best easiest way to work between the two real time and does 2013 give me any advantage over 2010?  

Open to suggestions before I jump down the rabbit hole.

Avatar of Tom Farrar
Tom Farrar
Flag of United States of America image

Are you saying the vlookup values might change for the spreadsheet you are importing into Access before the other spreadsheet can get uploaded?  In my opinion you should not load the vlookup fields to Access if the other Excel spreadsheet you are vlooking up from will also be loaded to Access.  The lookup values should be determined in Access after all the spreadsheets are loaded to Access.
Know that there is no way we can give you any targeted advice with out actually seeing these actual sheets, and you explaining all the detail to us.

Access and Excel work differently with "related" (Linked) data.

So while you can certainty substitute Dlookup for Vlookup (in some cases)
...The other "Linked" values must be handled differently .
So, at best you would need a few relationships between the new tables/sheets, worst you will need a complete redesign in some cases...

Avatar of Helen Feddema
Helen Feddema
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial