{"id":561841,"date":"2024-09-30T09:45:44","date_gmt":"2024-09-30T07:45:44","guid":{"rendered":"https:\/\/www.rebo.nl\/support\/non-knowledgebase\/uncategorized\/nicelabel-configure-a-database-connection\/"},"modified":"2026-05-27T12:23:50","modified_gmt":"2026-05-27T10:23:50","password":"","slug":"nicelabel-configure-a-database-connection","status":"publish","type":"docs","link":"https:\/\/www.rebo.nl\/en\/support\/nicelabel-en\/user-manual\/nicelabel-configure-a-database-connection\/","title":{"rendered":"NiceLabel configure a database connection"},"content":{"rendered":"<h4>Creating a label with a database connection<\/h4>\n<p>In the example on this page, we use an Excel file and link it to a label. However, you can also use other types of database files such as Access, Text Documents, and Google Sheets. <\/p>\n<p><span style=\"font-size: 10pt;\">Example of an Excel file:<\/span><\/p>\n<p><a href=\"https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/voorbeeld-Excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-450187\" src=\"https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/voorbeeld-Excel.jpg\" alt=\"\" width=\"491\" height=\"118\" srcset=\"https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/voorbeeld-Excel-200x48.jpg 200w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/voorbeeld-Excel-300x72.jpg 300w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/voorbeeld-Excel-360x87.jpg 360w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/voorbeeld-Excel-400x96.jpg 400w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/voorbeeld-Excel.jpg 491w\" sizes=\"(max-width: 491px) 100vw, 491px\" \/><\/a><\/p>\n<p><strong>Please note<\/strong>: The first row with columns in your Excel file is recognized by NiceLabel as column names. You should not modify these after importing. <\/p>\n<p>&nbsp;<\/p>\n<h4>How do I connect NiceLabel to an (Excel) database?<\/h4>\n<p><strong>1<\/strong>. Start NiceLabel Designer and create a label (or open an existing label). <\/p>\n<p><strong>2<\/strong>. On the left side of your screen, under the <em>Databases <\/em>option, click the <strong>+<\/strong> symbol.<br \/>\n<a class=\"awb-lightbox awb-lightbox-1\" href=\"https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-1-full.jpg\" data-rel=\"iLightbox\"><img decoding=\"async\" src=\"https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-1-small.jpg\"><\/a><\/p>\n<p><strong>3<\/strong>. Go through the first steps, then select the desired database type and click <em><strong>Next<\/strong><\/em>.<br \/>\n<a href=\"https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-3.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-450152\" src=\"https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-3.jpg\" alt=\"\" width=\"700\" height=\"515\" srcset=\"https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-3-200x147.jpg 200w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-3-300x221.jpg 300w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-3-360x265.jpg 360w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-3-400x294.jpg 400w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-3-500x368.jpg 500w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-3-600x441.jpg 600w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-3.jpg 700w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p><strong>4<\/strong>. Now click <strong><em>Browse<\/em><\/strong>, select your database file, and then click <strong><em>Next <\/em><\/strong>again. <strong><em><br \/>\n<a href=\"https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-4.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-450159\" src=\"https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-4.jpg\" alt=\"\" width=\"700\" height=\"515\" srcset=\"https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-4-200x147.jpg 200w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-4-300x221.jpg 300w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-4-360x265.jpg 360w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-4-400x294.jpg 400w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-4-500x368.jpg 500w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-4-600x441.jpg 600w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-4.jpg 700w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><br \/>\n<\/em><\/strong><\/p>\n<p><strong>5<\/strong>. You will now see an overview of the different fields (columns) found in your file.<br \/>\n<a href=\"https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-5.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-450166\" src=\"https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-5.jpg\" alt=\"\" width=\"700\" height=\"515\" srcset=\"https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-5-200x147.jpg 200w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-5-300x221.jpg 300w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-5-360x265.jpg 360w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-5-400x294.jpg 400w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-5-500x368.jpg 500w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-5-600x441.jpg 600w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-5.jpg 700w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p><strong>6<\/strong>. Next, choose whether you want to create <span style=\"text-decoration: underline;\">new text objects<\/span> based on the fields in your file (<strong>B<\/strong>) or link <span style=\"text-decoration: underline;\">existing texts<\/span> in your label to the correct fields later (<strong>A<\/strong>).<br \/>\nAfter you have made a choice, click <em><strong>Next<\/strong><\/em>.<br \/>\n<a href=\"https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-6.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-450173\" src=\"https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-6.jpg\" alt=\"\" width=\"700\" height=\"515\" srcset=\"https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-6-200x147.jpg 200w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-6-300x221.jpg 300w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-6-360x265.jpg 360w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-6-400x294.jpg 400w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-6-500x368.jpg 500w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-6-600x441.jpg 600w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-6.jpg 700w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p><strong>7<\/strong>. You will now see a preview of your Excel file. Press <em><strong>Finish <\/strong><\/em>to complete the database connection<br \/>\n<a href=\"https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-7.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-450180\" src=\"https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-7.jpg\" alt=\"\" width=\"700\" height=\"515\" srcset=\"https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-7-200x147.jpg 200w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-7-300x221.jpg 300w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-7-360x265.jpg 360w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-7-400x294.jpg 400w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-7-500x368.jpg 500w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-7-600x441.jpg 600w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Database-toevoegen-stap-7.jpg 700w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>Your database is now linked in NiceLabel, and it is now time to link the text objects to the correct database fields.<\/p>\n<p>&nbsp;<\/p>\n<h4>How do I link the fields from my (Excel) database to the text fields in my label?<\/h4>\n<p><strong>1<\/strong>. Select a desired text object and open the <em><strong>Source <\/strong><\/em>tab in the Properties (double-click on a text if the properties are not visible)<br \/>\n<strong>2<\/strong>. Expand the drop-down menu under <strong><em>Connected Data Source <\/em><\/strong>and select the desired database field here:<br \/>\n<a href=\"https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Tekstveld-koppelen.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-450194\" src=\"https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Tekstveld-koppelen.jpg\" alt=\"\" width=\"1000\" height=\"344\" srcset=\"https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Tekstveld-koppelen-200x69.jpg 200w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Tekstveld-koppelen-300x103.jpg 300w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Tekstveld-koppelen-360x124.jpg 360w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Tekstveld-koppelen-400x138.jpg 400w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Tekstveld-koppelen-500x172.jpg 500w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Tekstveld-koppelen-600x206.jpg 600w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Tekstveld-koppelen-700x241.jpg 700w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Tekstveld-koppelen-768x264.jpg 768w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Tekstveld-koppelen-800x275.jpg 800w, https:\/\/www.rebo.nl\/wp-content\/uploads\/2024\/09\/Tekstveld-koppelen.jpg 1000w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>As soon as you have linked all the desired fields, your label is ready to print!<\/p>\n<p>&nbsp;<\/p>\n<h4>View video<\/h4>\n<div class=\"fusion-video fusion-youtube\" style=\"--awb-max-width:600px;--awb-max-height:360px;\"><div class=\"video-shortcode\"><div class=\"fluid-width-video-wrapper\" style=\"padding-top:60%;\" ><iframe title=\"YouTube video player 1\" src=\"https:\/\/www.youtube.com\/embed\/-kUVDMB8BZw?wmode=transparent&autoplay=0&amp;rel=0\" width=\"600\" height=\"360\" allowfullscreen allow=\"autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture;\"><\/iframe><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Creating a label with a database connection In the example<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_improvement_type_select":"improve_an_existing","_thumb_yes_seoaic":false,"_frame_yes_seoaic":false,"seoaic_generate_description":"","seoaic_improve_instructions_prompt":"","seoaic_rollback_content_improvement":"","seoaic_idea_thumbnail_generator":"","thumbnail_generated":false,"thumbnail_generate_prompt":"","seoaic_article_description":"","footnotes":""},"doc_category":[9871],"doc_tag":[],"knowledge_base":[9868,9866,9861,9860,9867],"class_list":["post-561841","docs","type-docs","status-publish","hentry","doc_category-user-manual","knowledge_base-nicelabel-en","knowledge_base-sms-430-en","knowledge_base-sms-920-930-en","knowledge_base-sms-r1-en","knowledge_base-sms-tag-id2-en"],"year_month":"2026-06","word_count":403,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"support","author_nicename":"support","author_url":"https:\/\/www.rebo.nl\/en\/blog\/author\/support\/"},"doc_category_info":[{"term_name":"User Manual","term_url":"https:\/\/www.rebo.nl\/en\/support\/loftware-en\/user-manual\/"}],"doc_tag_info":[],"knowledge_base_info":[{"term_name":"NiceLabel","term_url":"https:\/\/www.rebo.nl\/en\/support\/nicelabel-en\/","term_slug":"nicelabel-en"},{"term_name":"SMS-430","term_url":"https:\/\/www.rebo.nl\/en\/support\/sms-430-en\/","term_slug":"sms-430-en"},{"term_name":"SMS-920 &amp; SMS-930","term_url":"https:\/\/www.rebo.nl\/en\/support\/sms-920-930-en\/","term_slug":"sms-920-930-en"},{"term_name":"SMS-R1","term_url":"https:\/\/www.rebo.nl\/en\/support\/sms-r1-en\/","term_slug":"sms-r1-en"},{"term_name":"SMS-TAG-ID2","term_url":"https:\/\/www.rebo.nl\/en\/support\/sms-tag-id2-en\/","term_slug":"sms-tag-id2-en"}],"knowledge_base_slug":["nicelabel-en","sms-430-en","sms-920-930-en","sms-r1-en","sms-tag-id2-en"],"_links":{"self":[{"href":"https:\/\/www.rebo.nl\/en\/wp-json\/wp\/v2\/docs\/561841","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rebo.nl\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.rebo.nl\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.rebo.nl\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rebo.nl\/en\/wp-json\/wp\/v2\/comments?post=561841"}],"version-history":[{"count":8,"href":"https:\/\/www.rebo.nl\/en\/wp-json\/wp\/v2\/docs\/561841\/revisions"}],"predecessor-version":[{"id":561849,"href":"https:\/\/www.rebo.nl\/en\/wp-json\/wp\/v2\/docs\/561841\/revisions\/561849"}],"wp:attachment":[{"href":"https:\/\/www.rebo.nl\/en\/wp-json\/wp\/v2\/media?parent=561841"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.rebo.nl\/en\/wp-json\/wp\/v2\/doc_category?post=561841"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.rebo.nl\/en\/wp-json\/wp\/v2\/doc_tag?post=561841"},{"taxonomy":"knowledge_base","embeddable":true,"href":"https:\/\/www.rebo.nl\/en\/wp-json\/wp\/v2\/knowledge_base?post=561841"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}