I am trying to create a one to many relationship using several linked excel spreadsheets.
I need the excel spreadsheets to be linked as they are updated on a weekly basis.
Once the relationships are created I want to combine certain columns from each spreadsheet using a query.
Once I have all the information I need on one table I need to import this into excel to create a profit per sale and total profit per month.
I have already created a database that suited my needs perfectly using Vlookup and various formulas, however, it has become too big and heavy to use.
I would like help and advice to optimize database. The above description with access is my theory on how to do this. If anyone can provide a more creative / effective way to assist I am all ears.
I have tried doing this myself and I am coming across error messages that I cannot solve by myself.
53 freelancers are bidding on average $138 for this job
Hello, I have substantial experience in excel and VBA, and I will be happy to assist you with your merging and formatting job. Please share your project details over chat. BR, Razvan
Hi, I am a professional Access developer I have done many projects in Access have a look at my profile. I have read your description could you contact me for details
Hi, I would like to suggest you to use MySQL as database. This can handle huge database and we can generate many reports like you need. Please let me know if we can discuss in more details. Thanks.
Hi, I am a Software Professional developing software in MS Access with VBA for last 22 years. I would like develop the database using MS Access as per your requirement and input provided by you.