This tool provides an easy way to convert CSV (TSV, TXT) files to SQL to be inserted into a database. Simply upload your CSV (TSV, TXT) file and the tool will create a sql file that contains INSERT/UPDATE statements to turn the CSV (TSV, TXT) file into records in a database table!
We invite you to subscribe Withdata Online Data Conversion Service (sign up as a member) to support this service.
Please Note:
- Make sure the first row of your CSV (TSV, TXT) file has headings which match your field names. ( No headings? See here.)
- If you want the tool to produce UPDATE statements, ensure you enter the Primary(Unique) key for your table in the field below. It must match exactly to the column in your CSV (TSV, TXT) file.
You can Sign Up as a member to increase max filesize to 10 MB.
Can not meet your need? No headings? File Size > 10 MB?
If the first row of your CSV (TSV, TXT) file has NO headings which match your field names, or you want to insert more complex data to database, such as DATE, TIMESTAMP field data to Oracle, or your file size > 10M, you can try these tools:
- For Oracle: OraLoader download page
- For Sql Server: TxtToSql download page
- For Mysql: TxtToMy download page
- For DB2: TxtToDB2 download page
- For Access: CsvToAccess download page
If you have any question, please contact us: