

mdb file contains fields, rows, tables, forms, macros, queries and reports.Īn. The file type rose in popularity as a result of the success of Microsoft Office and is a popular relational database file type due to its simplicity for creation and use by a novice. The MDB file extension was created by Microsoft and is the primary file type associated with the Microsoft Access applicaiton, which forms part of the Microsoft Office product set. The CSV file format is very simple and supported by almost all spreadsheets and database management systems.The benefit of this approach is that it allows the transfer of data across different applications. However CSV differs from other delimiter separated file formats in using a double quote character around fields that contain reserved characters (such as commas or newlines). CSV is one example of a delimited text file, which uses a comma to separate values (many other implementations of CSV allow different seperators such as back or forward slash to be used). In computers, a CSV file contains the different values in a table as a series of ASCII (American Standard Code for Information Interchange) text lines which are then organised so that each column value is separated by a comma from the next columns value and each row starts a new line. A CSV file is sometimes referred to as a flat file. Microsoft Excel, a leading spreadsheet or relational database application, can read CSV files. A CSV file is a way to collect the data from any table so that it can be conveyed as input to another table-oriented application such as a relational database application.
