How To Convert Excel To Flat File Database?

Asked By 15 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 10 points N/A #106065

How To Convert Excel To Flat File Database?

qa-featured

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.  

Related Questions