Convert access database to .csv file

Open Microsoft Access and create blank database. Click OK. Firstly open Access and create New Blank Database. Assign name to your newly created database in the File Name field and tap to the Create option. In the Access menu bar, tap to the External Data option. At last on the opened following pop-up window, tap to the Ok option. The following are the steps to convert accdb to CSV file format :. Open up your Microsoft Access database. Type the destination location of your file or use the Browse tool, then tap to the OK option.

Select the Comma as the delimiter. Set Text Qualifier to double quotation marks. Click Next , then click Finish. Within Access, select the database table you want to export. Within the Access menu bar, click File and then Export. Click OK on the following pop-up window. Sign up or log in Sign up using Google. Sign up using Facebook.

Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related Hot Network Questions. It depends on the version of your database. If your Access database is protected, fill-in your password as well.

In case you use Access workgroups and security, you will need to also find your system database and specify credentials for it. We will choose Text from the list of available source database formats and fill in connection properties. You can also specify the file filter if you wish. Default delimiter is Comma use it if you have comma-delimited files , but you can change it to Tab for tab-delimited files , or any other character.

All source tables are selected for conversion by default. In case you only need some tables, simply deselect the ones you don't need - or deselect all, then select just the tables you do need. Click the Copy your database button to get started. Conversion is highly-optimized to run as fast as possible, yet provides top-notch reliability.