Hi,
I want to run several different vba codes like the one below on an excel file that has several million rows. The excel file is so large that I cannot open it. Is there a way to run this in microsoft access instead and then run the a similar vba code on microsoft access? does microsoft access allow calculations?
HTML Code:
You can run queries in Access that will allow calculations. It is not as intuitive as Excel and has a steep learning curve. If you are interested in learning Access then here are three good reads.
1. Difference between Excel and Access http://forums.aspfree.com/microsoft-...el-349267.html
2. Fundatments of RDBMS design http://sbuweb.tcu.edu/bjones/20263/A...sDB_Design.pdf
3. Starting tutorial on building an Access db. http://www.accessmvp.com/strive4peace/
Alan
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks