Import xlsx, file to sqlite3 database

Source: Internet
Author: User
Tags sqlite database sqlite manager
Import xlsx, file to sqlite3 database work needs to use to the local database, need to import the XLSX table data into the SQLite database in the database in the app to use, looked at the next data to feel quite simple to share under the first is the need to view the database file software, Search the tool plugin-sqlite Manager directly on Firefox. You can view the database files, through the Shahe created a database file, you can open and view the database through this software to edit, it is convenient to import the database. Using code import is very similar to most of the lines of code sqlite>. open/users/apple/ Desktop/teachers.sqlite//Drag the database directly.
sqlite>. Separator "," sqlite>. Import/users/apple/desktop/teachers.csv teacher//Teac at the back She is the name of the table you created in the database, and in the table you want to create a field corresponding to the data in your CSV. However, it is important to note that you must first export the xlsx file to a CSV file. -Create a corresponding field in the database you are about to import. -The import will be error-free, but the data will pass. Error message: Expected 7 columns but found 8-extras ignored-sqlite>. Show//view section Settings-sqlite>. Help//view command required Links:-SQL end End of File: http://www.sqlite.org/download.html find the Mac download zip run terminal file to open the terminal database

Import xlsx, file to sqlite3 database

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.