The process by which IOS imports Excel into SQLite3

1. Open the Excel table and save as a. csv file

2. Open SQLite3, select File, Import, other ...

3. Select the. cvs file that you saved in step 1 in the file selection box that pops up

4 in the Pop-up dialog box, select File format as custom delimited, and the separator select ";" (. cvs file is actually a plain text file, the text is stored in the format, it is generally "," divided, but other character segmentation is also possible, like Apple is used ";" segmented)

5 Click the Import button to wait for success

The process by which IOS imports Excel into SQLite3