Cyber-D’s SQL Wizard 2.01

Posted by sew4tejhtr6ier Jumat, 08 Juni 2012 0 komentar

imageCyber-D's SQL wizard makes it easy to generate SQL queries from CSV data. This tool is ideal for people who need to insert large amounts of data into an SQL database. If you always receive Excel documents and need to insert the data into an SQL database, then this tool is ideal. Simply save the Excel document as a Comma Separated Value, import the file, change the variables (see video tutorial on product's website), click parse and save as SQL file. Now you can import the file in your SQL database.

 

  1. Export the Excel document as a CSV file (where “;” is used as a separator).
  2. Run SQL Wizard and browse for the csv or txt file.
  3. Give the columns in the CSV a unique identifier in the “CSV Column identifiers” field. You can use any name you like, as long as it’s between the [square brackets] and seperated by a semicolon. These variable names represent the columns of the CSV document in the same order.
  4. Modify the “SQL Insert Query” field to match your table name and table field names. Use the CSV Column identifiers you entered as values. 
  5. Click on “Parse” to generate the SQL Queries.
  6. Click on “Save as SQL” to save the SQL query on your desktop.
  7. Open the SQL file for inspection and load into SQL database when satisfied.

This tool can also be used to create any other type of queries if you modify the SQL Insert Query string to your needs.

A great alternative for my SQL Wizard is Exportizer. It has a lot more functions, processes data faster and supports more database formats.

PAD XML file

download1
TERIMA KASIH ATAS KUNJUNGAN SAUDARA
Judul: Cyber-D’s SQL Wizard 2.01
Ditulis oleh sew4tejhtr6ier
Rating Blog 5 dari 5
Semoga artikel ini bermanfaat bagi saudara. Jika ingin mengutip, baik itu sebagian atau keseluruhan dari isi artikel ini harap menyertakan link dofollow ke https://wallpaper-arts7.blogspot.com/2012/06/cyber-ds-sql-wizard-201.html. Terima kasih sudah singgah membaca artikel ini.

0 komentar:

Posting Komentar

Trik SEO Terbaru support Online Shop Baju Wanita - Original design by Bamz | Copyright of wallpaper art.