{"id":6310,"date":"2021-05-30T13:41:21","date_gmt":"2021-05-30T10:41:21","guid":{"rendered":"https:\/\/www.aso.com.tr\/?p=6310"},"modified":"2023-11-07T13:51:20","modified_gmt":"2023-11-07T10:51:20","slug":"database-excel-access-sql-etc-connection-in-barcode-label-program","status":"publish","type":"post","link":"https:\/\/www.aso.com.tr\/en\/database-excel-access-sql-etc-connection-in-barcode-label-program\/","title":{"rendered":"Database Excel, Access, SQL etc Connection in Barcode Label Program"},"content":{"rendered":"
\n

Barcode Label Program Database Connection (MS Excel, MS access, Text, SQL, ODBC)<\/h3>\n

<\/p>\n

Follow the steps by pressing the Data key.<\/p>\n

 <\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n
Database selection<\/td>\n <\/p>\n

This screen displays the selection screen for the databases supported by the program. Barcode Label Pro uses Microsoft OLEDB as database connection.<\/p>\n

 <\/td>\n<\/tr>\n

Microsoft Access<\/td>\n <\/p>\n

Press the Advanced button to change the general OLEDB connection settings to the desired you can change it like this.<\/p>\n

The Import key is used to import tables again. User name or If the password is entered incorrectly, you can use it after entering the correct one.<\/p>\n

 <\/td>\n<\/tr>\n

Microsoft Excel<\/td>\n <\/p>\n

Select the Excel file by pressing the Browse button. In the Tables section, the sheets (tabs) in the Excel file will appear.<\/p>\n

 <\/td>\n<\/tr>\n

Microsoft SQL Server<\/td>\n <\/p>\n

Instead of server, type the name or ip address. Select the security setting depending on the user name and password. By pressing the Fetch key
\nyou can ensure that the tables are listed.<\/p>\n

 <\/td>\n<\/tr>\n

ODBC Data Source<\/td>\n<\/p>\n

By pressing the Set button, the ODBC selection screen appears. Here you can select other selection from ODBC data sources defined by programs you can do it.<\/p>\n

<\/p>\n

\u00a0<\/span><\/p>\n<\/td>\n<\/tr>\n

Text File<\/td>\nBy pressing the Set button, the ODBC selection screen appears. Here you can select other selection from ODBC data sources defined by programs you can do it.<\/p>\n

<\/p>\n

Brackets;<\/b>columns in the text file indicate how they are separated from each other. The most commonly used commas and
\nis a tab. With Other you can select a single letter bracket of your choice.<\/p>\n

The first line contains the Title;<\/strong> In the first line of the file If there is header information, use it, otherwise use it in program order like field1,field2… will give names.<\/p>\n

Unicode;<\/b>file if ANSI (single character width)\u00a0If not, select Unicode.<\/td>\n<\/tr>\n

dBase<\/td>\nSelect the directory where the dBase files are located with the Select directory button. dBase tables are stored in separate files. Select the version of the dBase data. When the Export button is pressed\u00a0tables in the directory will come up.<\/td>\n<\/tr>\n
Paradox<\/td>\nIn separate files for each table in the Paradox database is kept. Therefore, use the Select Index button to select the index where the tables are located.<\/td>\n<\/tr>\n
Public OLEDB Provider<\/td>\nData added to the program that is not there by default base providers. From the following screen by pressing the Set button make the settings.<\/p>\n

<\/p>\n

 <\/td>\n<\/tr>\n

MsExcel Example<\/td>\nLet’s have the file data.xls in partition D of our hard disk and In this file, there are two tabs: stocks and current accounts. In step 1, we select Microsoft Excel. In step 2 we select the data.xls file on hard disk D with the browse button.
\n<\/p>\n

As seen in the screen above, the current and stocks tabs appeared in the Tables area. We select the Inventories tab.<\/p>\n

Press the Next button and select the next tab screen.<\/p>\n

<\/p>\n

Here, press the Optimized Width button to make the data more we can see it neatly.
\nWe finish the database binding process by pressing the Finish button.<\/p>\n

<\/p>\n

In the incoming Database screen, the data we connect to We can give criteria to our data with sorting and SQL commands in the base.<\/p>\n

 <\/p>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Barcode Label Program Database Connection (MS Excel, MS access, Text, SQL, ODBC) Follow the steps by pressing the Data key.   Database selection   This screen displays the selection screen for the databases supported by the program. Barcode Label Pro uses Microsoft OLEDB as database connection.   Microsoft Access   Press the Advanced button to…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_yoast_wpseo_focuskw":"","_yoast_wpseo_title":"","_yoast_wpseo_metadesc":"","footnotes":""},"categories":[63,64],"tags":[],"class_list":["post-6310","post","type-post","status-publish","format-standard","hentry","category-barcode-label-program-help","category-barkod-etiket-pro-en","entry","no-media"],"yoast_head":"\nDatabase Excel, Access, SQL etc Connection in Barcode Label Program - Aso Ajans<\/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:\/\/www.aso.com.tr\/en\/database-excel-access-sql-etc-connection-in-barcode-label-program\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database Excel, Access, SQL etc Connection in Barcode Label Program - Aso Ajans\" \/>\n<meta property=\"og:description\" content=\"Barcode Label Program Database Connection (MS Excel, MS access, Text, SQL, ODBC) Follow the steps by pressing the Data key.   Database selection   This screen displays the selection screen for the databases supported by the program. Barcode Label Pro uses Microsoft OLEDB as database connection.   Microsoft Access   Press the Advanced button to…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.aso.com.tr\/en\/database-excel-access-sql-etc-connection-in-barcode-label-program\/\" \/>\n<meta property=\"og:site_name\" content=\"Aso Ajans\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/asoreklam\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-30T10:41:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-07T10:51:20+00:00\" \/>\n<meta name=\"author\" content=\"Aso Ajans\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@asoreklam\" \/>\n<meta name=\"twitter:site\" content=\"@asoreklam\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Aso Ajans\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.aso.com.tr\\\/en\\\/database-excel-access-sql-etc-connection-in-barcode-label-program\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.aso.com.tr\\\/en\\\/database-excel-access-sql-etc-connection-in-barcode-label-program\\\/\"},\"author\":{\"name\":\"Aso Ajans\",\"@id\":\"https:\\\/\\\/www.aso.com.tr\\\/en\\\/#\\\/schema\\\/person\\\/baf75d37cf009d5cfada685686eac9d0\"},\"headline\":\"Database Excel, Access, SQL etc Connection in Barcode Label Program\",\"datePublished\":\"2021-05-30T10:41:21+00:00\",\"dateModified\":\"2023-11-07T10:51:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.aso.com.tr\\\/en\\\/database-excel-access-sql-etc-connection-in-barcode-label-program\\\/\"},\"wordCount\":543,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.aso.com.tr\\\/en\\\/#organization\"},\"articleSection\":[\"Barcode Label Program Help\",\"Barkod Etiket Pro\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.aso.com.tr\\\/en\\\/database-excel-access-sql-etc-connection-in-barcode-label-program\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.aso.com.tr\\\/en\\\/database-excel-access-sql-etc-connection-in-barcode-label-program\\\/\",\"url\":\"https:\\\/\\\/www.aso.com.tr\\\/en\\\/database-excel-access-sql-etc-connection-in-barcode-label-program\\\/\",\"name\":\"Database Excel, Access, SQL etc Connection in Barcode Label Program - Aso Ajans\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.aso.com.tr\\\/en\\\/#website\"},\"datePublished\":\"2021-05-30T10:41:21+00:00\",\"dateModified\":\"2023-11-07T10:51:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.aso.com.tr\\\/en\\\/database-excel-access-sql-etc-connection-in-barcode-label-program\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.aso.com.tr\\\/en\\\/database-excel-access-sql-etc-connection-in-barcode-label-program\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.aso.com.tr\\\/en\\\/database-excel-access-sql-etc-connection-in-barcode-label-program\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\\\/\\\/www.aso.com.tr\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database Excel, Access, SQL etc Connection in Barcode Label Program\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.aso.com.tr\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.aso.com.tr\\\/en\\\/\",\"name\":\"Aso Ajans Medya Ltd Sti\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.aso.com.tr\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.aso.com.tr\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.aso.com.tr\\\/en\\\/#organization\",\"name\":\"Aso Ajans Medya\",\"url\":\"https:\\\/\\\/www.aso.com.tr\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.aso.com.tr\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.aso.com.tr\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/aso-logo-4.jpg\",\"contentUrl\":\"https:\\\/\\\/www.aso.com.tr\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/aso-logo-4.jpg\",\"width\":476,\"height\":477,\"caption\":\"Aso Ajans Medya\"},\"image\":{\"@id\":\"https:\\\/\\\/www.aso.com.tr\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/asoreklam\",\"https:\\\/\\\/x.com\\\/asoreklam\",\"https:\\\/\\\/www.instagram.com\\\/asoajans\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/asoajans\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.aso.com.tr\\\/en\\\/#\\\/schema\\\/person\\\/baf75d37cf009d5cfada685686eac9d0\",\"name\":\"Aso Ajans\",\"sameAs\":[\"https:\\\/\\\/www.aso.com.tr\"],\"url\":\"https:\\\/\\\/www.aso.com.tr\\\/en\\\/author\\\/adminasoajans\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Database Excel, Access, SQL etc Connection in Barcode Label Program - Aso Ajans","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:\/\/www.aso.com.tr\/en\/database-excel-access-sql-etc-connection-in-barcode-label-program\/","og_locale":"en_US","og_type":"article","og_title":"Database Excel, Access, SQL etc Connection in Barcode Label Program - Aso Ajans","og_description":"Barcode Label Program Database Connection (MS Excel, MS access, Text, SQL, ODBC) Follow the steps by pressing the Data key.   Database selection   This screen displays the selection screen for the databases supported by the program. Barcode Label Pro uses Microsoft OLEDB as database connection.   Microsoft Access   Press the Advanced button to…","og_url":"https:\/\/www.aso.com.tr\/en\/database-excel-access-sql-etc-connection-in-barcode-label-program\/","og_site_name":"Aso Ajans","article_publisher":"https:\/\/www.facebook.com\/asoreklam","article_published_time":"2021-05-30T10:41:21+00:00","article_modified_time":"2023-11-07T10:51:20+00:00","author":"Aso Ajans","twitter_card":"summary_large_image","twitter_creator":"@asoreklam","twitter_site":"@asoreklam","twitter_misc":{"Written by":"Aso Ajans","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.aso.com.tr\/en\/database-excel-access-sql-etc-connection-in-barcode-label-program\/#article","isPartOf":{"@id":"https:\/\/www.aso.com.tr\/en\/database-excel-access-sql-etc-connection-in-barcode-label-program\/"},"author":{"name":"Aso Ajans","@id":"https:\/\/www.aso.com.tr\/en\/#\/schema\/person\/baf75d37cf009d5cfada685686eac9d0"},"headline":"Database Excel, Access, SQL etc Connection in Barcode Label Program","datePublished":"2021-05-30T10:41:21+00:00","dateModified":"2023-11-07T10:51:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.aso.com.tr\/en\/database-excel-access-sql-etc-connection-in-barcode-label-program\/"},"wordCount":543,"commentCount":0,"publisher":{"@id":"https:\/\/www.aso.com.tr\/en\/#organization"},"articleSection":["Barcode Label Program Help","Barkod Etiket Pro"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.aso.com.tr\/en\/database-excel-access-sql-etc-connection-in-barcode-label-program\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.aso.com.tr\/en\/database-excel-access-sql-etc-connection-in-barcode-label-program\/","url":"https:\/\/www.aso.com.tr\/en\/database-excel-access-sql-etc-connection-in-barcode-label-program\/","name":"Database Excel, Access, SQL etc Connection in Barcode Label Program - Aso Ajans","isPartOf":{"@id":"https:\/\/www.aso.com.tr\/en\/#website"},"datePublished":"2021-05-30T10:41:21+00:00","dateModified":"2023-11-07T10:51:20+00:00","breadcrumb":{"@id":"https:\/\/www.aso.com.tr\/en\/database-excel-access-sql-etc-connection-in-barcode-label-program\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.aso.com.tr\/en\/database-excel-access-sql-etc-connection-in-barcode-label-program\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.aso.com.tr\/en\/database-excel-access-sql-etc-connection-in-barcode-label-program\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/www.aso.com.tr\/en\/"},{"@type":"ListItem","position":2,"name":"Database Excel, Access, SQL etc Connection in Barcode Label Program"}]},{"@type":"WebSite","@id":"https:\/\/www.aso.com.tr\/en\/#website","url":"https:\/\/www.aso.com.tr\/en\/","name":"Aso Ajans Medya Ltd Sti","description":"","publisher":{"@id":"https:\/\/www.aso.com.tr\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.aso.com.tr\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.aso.com.tr\/en\/#organization","name":"Aso Ajans Medya","url":"https:\/\/www.aso.com.tr\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.aso.com.tr\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.aso.com.tr\/wp-content\/uploads\/2021\/05\/aso-logo-4.jpg","contentUrl":"https:\/\/www.aso.com.tr\/wp-content\/uploads\/2021\/05\/aso-logo-4.jpg","width":476,"height":477,"caption":"Aso Ajans Medya"},"image":{"@id":"https:\/\/www.aso.com.tr\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/asoreklam","https:\/\/x.com\/asoreklam","https:\/\/www.instagram.com\/asoajans\/","https:\/\/www.linkedin.com\/in\/asoajans\/"]},{"@type":"Person","@id":"https:\/\/www.aso.com.tr\/en\/#\/schema\/person\/baf75d37cf009d5cfada685686eac9d0","name":"Aso Ajans","sameAs":["https:\/\/www.aso.com.tr"],"url":"https:\/\/www.aso.com.tr\/en\/author\/adminasoajans\/"}]}},"_links":{"self":[{"href":"https:\/\/www.aso.com.tr\/en\/wp-json\/wp\/v2\/posts\/6310","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.aso.com.tr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.aso.com.tr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.aso.com.tr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.aso.com.tr\/en\/wp-json\/wp\/v2\/comments?post=6310"}],"version-history":[{"count":1,"href":"https:\/\/www.aso.com.tr\/en\/wp-json\/wp\/v2\/posts\/6310\/revisions"}],"predecessor-version":[{"id":6311,"href":"https:\/\/www.aso.com.tr\/en\/wp-json\/wp\/v2\/posts\/6310\/revisions\/6311"}],"wp:attachment":[{"href":"https:\/\/www.aso.com.tr\/en\/wp-json\/wp\/v2\/media?parent=6310"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aso.com.tr\/en\/wp-json\/wp\/v2\/categories?post=6310"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aso.com.tr\/en\/wp-json\/wp\/v2\/tags?post=6310"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}