Big Database

%3CLINGO-SUB%20id%3D%22lingo-sub-1500327%22%20slang%3D%22en-US%22%3EBig%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1500327%22%20slang%3D%22en-US%22%3EHi%20all%2C%3CBR%20%2F%3E%3CBR%20%2F%3ENeed%20your%20help%20to%20find%20a%20solution%20or%20a%20way%20to%20solve%20issue%2C%20So%20i'm%20working%20with%20a%20very%20large%20database%20which%20reachs%20to%207.5%20milion%20record%20in%20just%2045%20days%20and%20i'm%20working%20on%20week%20over%20week%20on%20excel%20and%20it%20is%20so%20exhausting%20and%20time%20wasting%20so%20tried%20to%20store%20it%20in%20access%20and%20it%20was%20very%20effective%20till%20excel%20can't%20read%20it%20on%20pivot%20table%20no%20more%3CBR%20%2F%3ECan%20anyone%20till%20me%20the%20solution%20for%20importing%20access%20database%20to%20make%20a%20pivot%20table%20as%20it%20gives%20me%20%22problem%20obtaining%20data%22%20error%20or%20another%20solution%20to%20work%20and%20update%20my%20data%20as%20its%20updated%20daily%3CBR%20%2F%3EThanks%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1500327%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1502167%22%20slang%3D%22en-US%22%3ERe%3A%20Big%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1502167%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F627719%22%20target%3D%22_blank%22%3E%40Mohamed_Gamal%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20try%20Power%20Query%20using%20the%20connector%20to%20Access%20database.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor
Hi all,

Need your help to find a solution or a way to solve issue, So i'm working with a very large database which reachs to 7.5 milion record in just 45 days and i'm working on week over week on excel and it is so exhausting and time wasting so tried to store it in access and it was very effective till excel can't read it on pivot table no more
Can anyone till me the solution for importing access database to make a pivot table as it gives me "problem obtaining data" error or another solution to work and update my data as its updated daily
Thanks
3 Replies

@Mohamed_Gamal 

You may try Power Query using the connector to Access database.

Can you show me how or link a Tutorial for it but i think it will also make excel give me the same error as if excel will red the database from power query will freeze with the huge numbwr of records or maybe i don't understand xan you tell me how please

@Mohamed_Gamal 

You may check https://www.dummies.com/software/microsoft-office/excel/how-to-query-an-access-database-tables-from-... and I believe you may google for more.

 

As I understood you need to import into the data model, not into Excel sheet, thus you have chances. Data model on practice is limited only by memory size. Another story is performance, it depends.

 

And perhaps you don't need entire Access table, only part of it, if so you may apply filter / columns transformation in Power Query.