MS Excel usage for storing data in form of files

Asked By David E Barnes 35 points N/A Posted on - 03/17/2015

Hi! I have always heard that MS Excel has been used in a wide range of applications over the years but recently I heard something very surprising. Apparently, a lot of people have used it before as an alternative to database management systems. I mean is it possible to actually use MS Excel to store your important data in the form of files because obviously MS Excel has different functionalities and it seems very inappropriate to use it for storing data in form of files

• Status: Open
• Question Views: 518
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Samuel Kaut 5 points N/A #183716

MS Excel usage for storing data in form of files

Hello,

We can export the MS Access database files into MS Excel spreadsheet to store the files. In this way we are storing .mdb files into .xls or .xlsx files. Ms Access having in-built utility called as “Export Wizard” using this we can export database objects like queries, tables, forms etc. When data are exported, Access forms a copy and then stores the created copy in the Excel file.
See the option of Export Wizard as:

About Samuel Kaut

Questions
3

Answers
103

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 03/18/2015
• Question Category: MS Excel

Answered By Azganthor Herld 0 points N/A #183718

MS Excel usage for storing data in form of files

MS excel can store only data, but not in form of files. In other words, MS excel cannot store files.

It has multiple workarounds that are

1. Macro Programming: By using this, we can automate different tasks in MS excel by writing a VBA (Visual Basic for Applications) code in Visual Basic Editor.

2. Organizing Data: Excel is widely used for creating line graphs, Bar graphs and charts/pie charts that helps in creating  reports also.

3. For exporting and importing data: Excel can interact with MS Access, MS word and external data sources to send and receive data.

About Azganthor Herld

Questions
0

Answers
43

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 03/18/2015
• Question Category: MS Excel