# ODBCSV
Query an ODBC data source and output the result as CSV or to insert from CSV into an ODBC data source.
## Installation
Several installation options are available.
### Download prebuild binaries
You can download the latest binaries here from the `odbc-api` GitHub release: <https://github.com/pacman82/odbc-api/releases/latest>.
### Install using cargo
```shell
cargo install odbcsv
```
## Usage
### Querying an Microsoft SQL Database and storing the result in a file
```shell
odbcsv query \
--output query.csv \
--connection-string "Driver={ODBC Driver 17 for SQL Server};Server=localhost;UID=SA;PWD=<YourStrong@Passw0rd>;" \
"SELECT title, year from Movies"
```
### Query using data source name
```bash
odbcsv query \
--output query.csv \
--dsn my_db \
--password "<YourStrong@Passw0rd>" \
--user "SA" \
"SELECT * FROM Birthdays"
```
### Use parameters in query
```shell
odbcsv query \
--output query.csv \
--connection-string "Driver={ODBC Driver 17 for SQL Server};Server=localhost;UID=SA;PWD=<YourStrong@Passw0rd>;" \
"SELECT * FROM Birthdays WHERE year > ? and year < ?" \
1990 2010
```
Use `--help` to see all options.