Let’s say you have received a set of data in 25 different spreadsheets. In this post, you’ll learn about this in-built Macro function in MS Access to import data known as “ ImportExportSpreadsheet”. So, I started thinking of importing these multiple files into a single table of MS Access, then run queries as per my needs. When I went through the data, I realised I might have to add some helper columns to add some more details – but doing so in each and every spreadsheet was going to be too time consuming. So, the concerned data operator gave me the data in multiple spreadsheets (MS Excel) with each spreadsheet of significant file size running into 100s of MBs. ![]() ![]() While the data was available at a reasonable level of detail, it was too big to come in one spreadsheet. Recently, I had requested a big size of sales/inventory data from one of our internal team.
0 Comments
Leave a Reply. |