Cov txheej txheem:

Kuv yuav import Excel li cas rau hauv SQLite?
Kuv yuav import Excel li cas rau hauv SQLite?

Video: Kuv yuav import Excel li cas rau hauv SQLite?

Video: Kuv yuav import Excel li cas rau hauv SQLite?
Video: Python! Writing pandas DataFrames to Multiple Tabs in a Spreadsheet 2024, Hlis ntuj nqeg
Anonim

Nyem thiab qhib qhov "Table" thiab "Existing Worksheet" xaiv hauv Qhov Ntshuam Cov ntaub ntawv qhov rai. Nyem ib khoob cell ntawm Excel phau ntawv qhov twg koj xav tau cov ntaub ntawv rooj los ntawm SQLite database kom tshwm. Nyem qhov "OK" khawm.

Kuj kom paub yog, kuv yuav import cov ntaub ntawv rau hauv SQLite li cas?

Koj tuaj yeem import CSV cov ntaub ntawv ncaj qha rau hauv SQLite rooj los ntawm nws lub rooj saib:

  1. Qhib cov lus lo lus uas peb saib ces xaiv Cov Ntaub Ntawv -> Ntshuam CSV los ntawm cov ntawv qhia zaub mov.
  2. Lossis koj tuaj yeem nyem rau ntawm lub npe lub rooj los ntawm lub vaj huam sib luag sab xis (lossis txawm tias cov ntaub ntawv xov tooj ntawm lub rooj), xaiv Ntshuam CSV.

Qhov thib ob, yog SQLite dawb? SQLite yog lub tsev qiv ntawv hauv txheej txheem uas siv tus kheej muaj, serverless, xoom-configuration, kev hloov pauv SQL database cav. Code rau SQLite yog nyob rau hauv pej xeem sau thiab yog li ntawd dawb siv rau txhua lub hom phiaj, coj mus muag lossis ntiav. SQLite yog ib lub tsev qiv ntawv compact.

Ib sab ntawm no, leej twg ntawm cov lus txib hauv qab no yog siv los import cov ntaub ntawv CSV rau lub rooj SQLite?

Cov ". ntshuam " lus txib yog siv los import CSV cov ntaub ntawv rau hauv ib SQLite rooj . Cov ". ntshuam " lus txib siv ob qhov kev sib cav uas yog lub npe ntawm lub disk ntaub ntawv los ntawm qhov twg CSV cov ntaub ntawv yuav tsum tau nyeem thiab lub npe ntawm tus SQLite rooj rau hauv qe cov CSV cov ntaub ntawv yuav tsum tau muab tso rau.

Kuv yuav qhib. DB cov ntaub ntawv hauv Excel li cas?

Txoj nyem rau ntawm lub. db file > Qhib nrog> Xaiv Qhov Kev Pabcuam Default> Nyem rau Saib, thiab xauj rau C: ProgramFilesMicrosoft OfficeOffice 14 Excel > xyuas kom txhua lub program no mus qhib zoo li no ntaub ntawv thiab nias rau Ok.

Pom zoo: