CODEWITHSUNDEEP
powershellsqlitecsvimport
HBasiri
HBasiri

Reputation: 373

How to import CSV file using PowerShell?

I want to import a CSV File (comma delimited with double quote) into SQLite using PowerShell script. I tried:

echo ".import export.csv mytable" | sqlite3.exe

I get this error:

export.csv:327: unescaped " character

I get this error for all lines. On SQLite's command line shell same command works:

sqlite > .import export.csv mytable

How can I make this command work using a PowerShell script?

Upvotes: 3

Views: 3268

Answers (3)

qyb2zm302
qyb2zm302

Reputation: 6458

The following single command line works in both

  • cmd.exe (version 10.0.x.x via ver) and
  • powershell.exe (version 5.1.x.x via $PSVersionTable)
.\sqlite3.exe my.db ".import file1.csv table1 --csv"

This loads the contents of csv file file1.csv into table table1 within the sqlite database file my.db. The --csv flag will import the file and create the table structure based on the header column names in that file, and will approximately infer the data types.

You can import multiple files this way. i.e.

.\sqlite3.exe my.db ".import file1.csv table1 --csv" ".import file2.csv table2 --csv"

You can chain commands together to immediately open the database for querying by appending ; .\sqlite3.exe my.db.

i.e.

.\sqlite3.exe my.db ".import file1.csv table1 --csv" ".import file2.csv table2 --csv; .\sqlite3.exe my.db"

Upvotes: 1

d3Xt3r
d3Xt3r

Reputation: 203

This works for me in both PowerShell 5.1 and v7.0.

$params = @"
.mode csv
.separator ,
.import export.csv mytable
"@

$params | .\sqlite3.exe mydatabase.db

Upvotes: 3

Prasoon Karunan V
Prasoon Karunan V

Reputation: 3043

what about sqlite3.exe ".import export.csv mytable".

You can check the documentation of sqlite3.exe to use it not being in its shell, how to pass parameter to sqlite3.exe.

You can try below line

Invoke-Expression 'sqlite3 yourdatabase.db < ".import export.csv mytable"'

Upvotes: 0

Related Questions