Converting CSV Files To SQL - The Easy Way

- June 16, 2009, 2:34 pm | Working With Data

Add to del.icio.us | Digg

---

Managing your data, including importing data into a database for use on a web site, sometimes requires the right tools to di it quickly and efficiently. In the past we provided our customers various database formats, including CSV and SQL. But with the right tool you can now convert your raw data yourself.

We have used a free tool, CSV to SQL converter, for a while now. The program was written to make importing data into a MySQL database easier. The program can:

• Convert CSV files to SQL files,


• Split up the SQL file into smaller files with a specified number of rows,


• Convert Unix linefeed into Windows type


• Specifie whether or not field names are requested.

We have used this program to successfullyconvert very large (3,000,000 records and 10 fields) CSV files into SQL.

While we still use our Z Quick Import program to import large CSV files directly into a MySQL database we still find a lot of uses for the CSV to SQL converter. Check out this site.

---

CSV to SQL Converter



Keywords: database converter csv to sql

---

Recently Added:

1. Problems With Variables Not Being Passed To A Page - Coding Tips
2. 12,000,000 Page Web Site - 12 Million Page Web Site
3. Converting CSV Files To SQL The Easy Way - Working With Data
4. Mod Rewrite For SE Friendly URLs A Practical Example - Coding Tips
5. Read This Before You Buy A Database - Database Notices

Copyright © 1993-2009 USPN Tech, All Rights Reserved