CODEWITHSUNDEEP
excelperformancems-access
DanCo89
DanCo89

Reputation: 11

Large Excel files- is Access a better platform for data analysis

I have an excel file w/ 600k line items (about 15 columns). Opening it, much less performing analysis is extremely slow on my not-exactly-a-super-computer (doing a simple VLOOKUP on 1/3 of the dataset takes 10 min and will often crash). I have Access 2010 at my disposal. Is that a) suitable for inputting weekly data and returning some basic summary stats (SKUs rolled up by plant) and, b) significantly faster than an Excel workbook w/ 500k-1M rows?

Upvotes: 0

Views: 61

Answers (1)

Joel Wembo
Joel Wembo

Reputation: 870

I won't advise moving from to Excel to Access , SQL server or oracle will be better because it seem like you do have a large database to handle and you also want Speed and consistency. Moving your data from Excel to SQL server will be great.

Upvotes: 1

Related Questions