How To Convert Excel To Flat File Database?

Asked By R Palmer 15 points N/A Posted on - 09/13/2016

I want to convert Excel to flat file database where it has all the data separated by acomma and well-spaced manner. And also it needs to be quicker to access and easy to retrieve data from and to thedatabase.

• Status: Open
• Question Views: 872
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By G Brown 10 points N/A #106065

How To Convert Excel To Flat File Database?

To convert Excel into a flat file database that is comma separated you can save the file as a CSV file which may not have any formatting’s but it will only store data that will be really very fast to access.

Step 1: Open the Excel file and click on save as from file menu.

Step 2: Enter the name of the file and in the file type dialog box select CSV (comma delimited).

Step 3: Click on the Save button The file will be stored into a flat file with the extension of CSV.  

About G Brown

Questions
18

Answers
11

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 09/13/2016
• Question Category: MS Excel