{"id":2347,"date":"2025-10-23T12:22:02","date_gmt":"2025-10-23T11:22:02","guid":{"rendered":"https:\/\/wiskunst.nl\/?page_id=2347"},"modified":"2026-03-04T10:13:35","modified_gmt":"2026-03-04T09:13:35","slug":"excel-excel2sql","status":"publish","type":"page","link":"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-excel2sql\/","title":{"rendered":"Excel-Excel2SQL"},"content":{"rendered":"

In de add-in Handigheidjes zit een wizard waarmee u Excel-tabellen kunt omzetten naar SQL-scripts.<\/h4>\n

U krijgt tabellen aangeleverd die verwerkt moeten worden in uw database. Vaak zullen deze tabellen aangeleverd worden in csv-formaat of in Excel, maar vrijwel nooit in een formaat die uw database kan afhandelen.<\/p>\n

De wizard Excel2SQL biedt uitkomst!<\/p>\n

U maakt in Excel van de tabellen “echte” Excel-tabellen. Daarna start u de wizard op.
\nDe wizard bestaat uit een aantal stappen:<\/p>\n

Zo kiest u bijvoorbeeld welke scripts u wilt aanmaken en kiest u uw gewenste RDBMS:<\/p>\n

\"De
De Excel2SQL wizard van HJGSoft Handigheidjes: Keuze maken<\/figcaption><\/figure>\n

U kiest van welke tabellen u scripts wilt maken:<\/p>\n

\"De
De Excel2SQL wizard van HJGSoft Handigheidjes: Tabellen kiezen<\/figcaption><\/figure>\n

Per gekozen tabel stelt u een aantal zaken in:<\/p>\n

\"De
De Excel2SQL wizard van HJGSoft Handigheidjes: Tabel instellingen<\/figcaption><\/figure>\n

U kunt zelfs relaties aangeven:<\/p>\n

\"De
De Excel2SQL wizard van HJGSoft Handigheidjes: Relaties<\/figcaption><\/figure>\n

Voordat de scripts worden aangemaakt krijgt u een overzicht van wat u gekozen heeft en de controles hierop:<\/p>\n

\"De
De Excel2SQL wizard van HJGSoft Handigheidjes: Overzicht<\/figcaption><\/figure>\n

Hierna worden de scripts aangemaakt.<\/p>\n

Wanneer er iets dreigt fout te gaan dan constateert de wizard dat:<\/p>\n

\"De
De Excel2SQL wizard van HJGSoft Handigheidjes: Overzicht met fouten<\/figcaption><\/figure>\n

De wizard zit vol met intelligentie:<\/p>\n

De wizard<\/p>\n

    \n
  • kijkt of alle gekozen tabellen unieke namen hebben<\/li>\n
  • kijkt of alle gekozen kolommen binnen de tabellen unieke namen hebben<\/li>\n
  • kijkt in de gekozen tabellen of de aangegeven primaire sleutel uniek is<\/li>\n
  • kijkt in de gekozen tabellen of de vreemde sleutels voorkomen in de gekoppelde tabellen<\/li>\n
  • bepaalt zelf het type per kolom zodat alle waardes hierin passen<\/li>\n
  • bepaalt voor tekst- en decimaal-velden de juiste grootte en soort<\/li>\n<\/ul>\n

    De wizard is in staat om insert-scripts alsook create-scripts te maken.<\/p>\n

    De wizard werkt op dit moment voor MySQL, Oracle en MS-SQLServer.<\/p>\n

    Opmerking<\/strong>: De verwijzingen naar HJGSoft zijn niet meer actief omdat HJGSoft niet meer actief is. Wellicht dat in de toekomst een deel van de functionaliteiten op deze site gepubliceerd gaat worden.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

    In de add-in Handigheidjes zit een wizard waarmee u Excel-tabellen kunt omzetten naar SQL-scripts. U krijgt tabellen aangeleverd die verwerkt moeten worden in uw database. Vaak zullen deze tabellen aangeleverd worden in csv-formaat of in Excel, maar vrijwel nooit in een formaat die uw database kan afhandelen. De wizard Excel2SQL biedt uitkomst! U maakt in […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":2339,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"templates\/template-full-width.php","meta":{"_lmt_disableupdate":"no","_lmt_disable":"","footnotes":""},"class_list":["post-2347","page","type-page","status-publish","hentry"],"yoast_head":"\nExcel-Excel2SQL - Wiskunst<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-excel2sql\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel-Excel2SQL - Wiskunst\" \/>\n<meta property=\"og:description\" content=\"In de add-in Handigheidjes zit een wizard waarmee u Excel-tabellen kunt omzetten naar SQL-scripts. U krijgt tabellen aangeleverd die verwerkt moeten worden in uw database. Vaak zullen deze tabellen aangeleverd worden in csv-formaat of in Excel, maar vrijwel nooit in een formaat die uw database kan afhandelen. De wizard Excel2SQL biedt uitkomst! U maakt in […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-excel2sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Wiskunst\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-04T09:13:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wiskunst.nl\/wp-content\/uploads\/2025\/11\/HJG_Excel2SQL_03.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"612\" \/>\n\t<meta property=\"og:image:height\" content=\"543\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/wiskunst.nl\\\/index.php\\\/hjgsoft\\\/excel-handigheidjes\\\/excel-excel2sql\\\/\",\"url\":\"https:\\\/\\\/wiskunst.nl\\\/index.php\\\/hjgsoft\\\/excel-handigheidjes\\\/excel-excel2sql\\\/\",\"name\":\"Excel-Excel2SQL - Wiskunst\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wiskunst.nl\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/wiskunst.nl\\\/index.php\\\/hjgsoft\\\/excel-handigheidjes\\\/excel-excel2sql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/wiskunst.nl\\\/index.php\\\/hjgsoft\\\/excel-handigheidjes\\\/excel-excel2sql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/wiskunst.nl\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/HJG_Excel2SQL_03.jpg\",\"datePublished\":\"2025-10-23T11:22:02+00:00\",\"dateModified\":\"2026-03-04T09:13:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/wiskunst.nl\\\/index.php\\\/hjgsoft\\\/excel-handigheidjes\\\/excel-excel2sql\\\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/wiskunst.nl\\\/index.php\\\/hjgsoft\\\/excel-handigheidjes\\\/excel-excel2sql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/wiskunst.nl\\\/index.php\\\/hjgsoft\\\/excel-handigheidjes\\\/excel-excel2sql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/wiskunst.nl\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/HJG_Excel2SQL_03.jpg\",\"contentUrl\":\"https:\\\/\\\/wiskunst.nl\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/HJG_Excel2SQL_03.jpg\",\"width\":612,\"height\":543},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/wiskunst.nl\\\/index.php\\\/hjgsoft\\\/excel-handigheidjes\\\/excel-excel2sql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/wiskunst.nl\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"HJGSoft\",\"item\":\"https:\\\/\\\/wiskunst.nl\\\/index.php\\\/hjgsoft\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel Handigheidjes\",\"item\":\"https:\\\/\\\/wiskunst.nl\\\/index.php\\\/hjgsoft\\\/excel-handigheidjes\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Excel-Excel2SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/wiskunst.nl\\\/#website\",\"url\":\"https:\\\/\\\/wiskunst.nl\\\/\",\"name\":\"Wiskunst\",\"description\":\"2\u221e\u2227>\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/wiskunst.nl\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel-Excel2SQL - Wiskunst","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-excel2sql\/","og_locale":"nl_NL","og_type":"article","og_title":"Excel-Excel2SQL - Wiskunst","og_description":"In de add-in Handigheidjes zit een wizard waarmee u Excel-tabellen kunt omzetten naar SQL-scripts. U krijgt tabellen aangeleverd die verwerkt moeten worden in uw database. Vaak zullen deze tabellen aangeleverd worden in csv-formaat of in Excel, maar vrijwel nooit in een formaat die uw database kan afhandelen. De wizard Excel2SQL biedt uitkomst! U maakt in […]","og_url":"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-excel2sql\/","og_site_name":"Wiskunst","article_modified_time":"2026-03-04T09:13:35+00:00","og_image":[{"width":612,"height":543,"url":"https:\/\/wiskunst.nl\/wp-content\/uploads\/2025\/11\/HJG_Excel2SQL_03.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"3 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-excel2sql\/","url":"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-excel2sql\/","name":"Excel-Excel2SQL - Wiskunst","isPartOf":{"@id":"https:\/\/wiskunst.nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-excel2sql\/#primaryimage"},"image":{"@id":"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-excel2sql\/#primaryimage"},"thumbnailUrl":"https:\/\/wiskunst.nl\/wp-content\/uploads\/2025\/11\/HJG_Excel2SQL_03.jpg","datePublished":"2025-10-23T11:22:02+00:00","dateModified":"2026-03-04T09:13:35+00:00","breadcrumb":{"@id":"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-excel2sql\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-excel2sql\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-excel2sql\/#primaryimage","url":"https:\/\/wiskunst.nl\/wp-content\/uploads\/2025\/11\/HJG_Excel2SQL_03.jpg","contentUrl":"https:\/\/wiskunst.nl\/wp-content\/uploads\/2025\/11\/HJG_Excel2SQL_03.jpg","width":612,"height":543},{"@type":"BreadcrumbList","@id":"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-excel2sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/wiskunst.nl\/"},{"@type":"ListItem","position":2,"name":"HJGSoft","item":"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/"},{"@type":"ListItem","position":3,"name":"Excel Handigheidjes","item":"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/"},{"@type":"ListItem","position":4,"name":"Excel-Excel2SQL"}]},{"@type":"WebSite","@id":"https:\/\/wiskunst.nl\/#website","url":"https:\/\/wiskunst.nl\/","name":"Wiskunst","description":"2\u221e\u2227>","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wiskunst.nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"}]}},"_links":{"self":[{"href":"https:\/\/wiskunst.nl\/index.php\/wp-json\/wp\/v2\/pages\/2347","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wiskunst.nl\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/wiskunst.nl\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/wiskunst.nl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wiskunst.nl\/index.php\/wp-json\/wp\/v2\/comments?post=2347"}],"version-history":[{"count":5,"href":"https:\/\/wiskunst.nl\/index.php\/wp-json\/wp\/v2\/pages\/2347\/revisions"}],"predecessor-version":[{"id":2544,"href":"https:\/\/wiskunst.nl\/index.php\/wp-json\/wp\/v2\/pages\/2347\/revisions\/2544"}],"up":[{"embeddable":true,"href":"https:\/\/wiskunst.nl\/index.php\/wp-json\/wp\/v2\/pages\/2339"}],"wp:attachment":[{"href":"https:\/\/wiskunst.nl\/index.php\/wp-json\/wp\/v2\/media?parent=2347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}