Skip to main content

Posts

Showing posts with the label access database

How to import CSV into Microsoft Access database?

CSV is a simple file format used to store table data, such as a spreadsheet or database. You can import and export CSV format files from tables that store data in tables such as Microsoft Excel or Open Office Calc. CSV means "comma-separated values". If you need to import the CSV into an Access database, here is the step-by-step guide to doing that. First, you need to open the Microsoft Access and navigate the "File menu". Then  Open or create a new database for CSV data. Then you can create a new table and set all the required fields, or you can import CSV data to create a new table. Go to the "External Data" tab of Microsoft Access and click on the "Text File" as shown on the screenshot below. Click the "Browse" button and select the CSV file. (* Note: The file name must be less than 64 characters, otherwise Microsoft Access will not be able to import it). In this case, you might get an error like "Unrecognized Databa...