N/APosted 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.
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.