This is the first step to establish a simple and free database to hold stock quotes downloaded from Yahoo Finance!

YahooFinance_odb_table.R

require(ODB)

database_path = "~/example_path/my_database.odb"

# Create a database
odb.create(database_path)

# Connect to the database
ODB <- odb.open(database_path)

# Creation of a new table to hold future data from Yahoo Finance!
SQL <- "CREATE TABLE stock (id INTEGER PRIMARY KEY, date DATE, open DOUBLE, high DOUBLE, low DOUBLE, close DOUBLE, volume DOUBLE, adjclose DOUBLE, name VARCHAR(10))"
odb.write(ODB, SQL)

# Save changes and close connection
odb.close(ODB, write = TRUE)