Abstract
Import a CSV file into a SQL database table.
Table of Contents
Import a CSV file into a SQL database table.
This script opens a CSV file, and places the values into a freshly created database table. It attempts to guess as much as it can from the file (e.g. which data types to create).
You can use the first row to name the columns (use the -c option). You can also use a row to explicitly specify the data type of each column (use the -t option); otherwise it will try to make an educated guess using the first few rows of the table (you can change the number, see options).
Important
This computer program or library is provided for free. I am aware that some of the programs that I provide for free allow people to get their work done faster or better, save them time and money. If you are using this program for benefit, especially if you are using it within a commercial environment and it saves you time or work, please consider making a donation by sending me a book from my Amazon Wishlist or by a direct donation to my company's PayPal account by clicking on the link below.