{"id":1578,"date":"2021-01-17T12:54:21","date_gmt":"2021-01-17T18:54:21","guid":{"rendered":"http:\/\/accessusergroups.org\/?p=1578"},"modified":"2021-01-17T12:54:21","modified_gmt":"2021-01-17T18:54:21","slug":"accesssqltool","status":"publish","type":"post","link":"https:\/\/accessusergroups.org\/blog\/accesssqltool\/","title":{"rendered":"Introducing Access to TSQL Converter + VBA Tool"},"content":{"rendered":"

I’m proud to announce a new groundbreaking tool at https:\/\/accessusergroups.org\/sql-converter\/<\/a> to help Access developers worldwide on making the transition over to SQL Server much easier. The tool will convert your Access query SQL to SQL Server’s TSQL language for easy pasting into your code or SQL Server Management Studio.<\/p>\n

Why we built this tool<\/strong><\/p>\n

Those of you who work a lot with Access and SQL Server, in particular when upgrading an existing Access application, will no doubt appreciate the convenience of being able to convert queries with ease Granted, a lot of simple Select queries don’t need translation, but for the rest, in particular action queries, it will be a boon in productivity.<\/p>\n

How it works<\/strong><\/p>\n

Paste your Access query on the left panel, click on the “Convert” button and see your TSQL equivalent on the right, it’s that easy:<\/p>\n

Plugin the following Access query:<\/p>\n

SELECT tblEvents.*, tblEstimates.OrderNum, tblCompanies.Company, tblEmployees.Employee, \r\ntblEstimates.JobName, tblEventTypes.EventType, tblEventStatus.EventStatus, \r\ntblCompanies.Company\r\nFROM ((((tblEvents LEFT JOIN tblCompanies ON tblEvents.CompanyID = tblCompanies.CompanyID) \r\nLEFT JOIN tblEmployees ON tblEvents.EmployeeID = tblEmployees.EmployeeID) \r\nLEFT JOIN tblEventStatus ON tblEvents.EventStatusID = tblEventStatus.EventStatusID) \r\nLEFT JOIN tblEventTypes ON tblEvents.EventTypeID = tblEventTypes.EventTypeID) \r\nLEFT JOIN tblEstimates ON tblEvents.EstimateID = tblEstimates.EstimateID\r\nWHERE (((tblCompanies.Company) Like \"*inc*\"));<\/pre>\n
And get the TSQL equivalent:<\/p>\n
SELECT tblEvents.*\r\n,tblEstimates.OrderNum\r\n,tblCompanies.Company\r\n,tblEmployees.Employee\r\n,tblEstimates.JobName\r\n,tblEventTypes.EventType\r\n,tblEventStatus.EventStatus\r\n,tblCompanies.Company \r\nFROM ((((tblEvents\r\nLEFT JOIN tblCompanies ON tblEvents.CompanyID = tblCompanies.CompanyID)\r\nLEFT JOIN tblEmployees ON tblEvents.EmployeeID = tblEmployees.EmployeeID)\r\nLEFT JOIN tblEventStatus ON tblEvents.EventStatusID = tblEventStatus.EventStatusID)\r\nLEFT JOIN tblEventTypes ON tblEvents.EventTypeID = tblEventTypes.EventTypeID)\r\nLEFT JOIN tblEstimates ON tblEvents.EstimateID = tblEstimates.EstimateID \r\nWHERE (((tblCompanies.Company) LIKE '%inc%'))<\/pre>\n
Notice the following:<\/p>\n
    \n
  • The system will format your SQL for easy reading.<\/li>\n
  • It will also convert Access syntax to TSQL syntax, for example the Where clause WHERE (((tblCompanies.Company) Like “*inc*”));<\/em> turns into: WHERE (((tblCompanies.Company) LIKE ‘%inc%’)).\u00a0<\/em>The tool converted “*” into “%” and the double quotes into single quotes.<\/li>\n<\/ul>\n
    BUT WAIT, THERE’S MORE!<\/strong><\/p>\n
    You will notice there’s a VBA tab on each side, clicking on each will provide you with a text string you can easily paste into your code:<\/p>\n
    \"\"<\/pre>\n
    Now you don’t have to spend hours on each project converting your queries to code, just paste into the tool, click on the VBA tab and copy to your code, a real time saver! Notice you can remove vbCrLf by unchecking it on the upper right:<\/p>\n
    \"\"
    Don’t want vbCrLf? Uncheck it on the upper right<\/figcaption><\/figure>\n
    Dark Mode<\/strong><\/p>\n
    Get Dark Mode by selecting on the upper left:<\/p>\n
    \"\"<\/p>\n
    Watch the SQL Version<\/strong><\/p>\n
    Make sure to select the correct SQL version of your server since each version may have differences in your conversion:<\/p>\n
    \"\"<\/p>\n
    Limitations<\/strong><\/p>\n
      \n
    • The converter will not replace custom functions in your VBA.<\/li>\n
    • It’s not going to check if your query makes sense or is proper. For example, trying to query a local Access table in SQL Server will fail since the table is in Access, not SQL.<\/li>\n
    • It will not replace form references such as WHERE [frmCustomer].[CustomerID] = 100.<\/li>\n<\/ul>\n
      This is still a work in progress, help us make it better!<\/strong><\/p>\n
      Please leave us feedback in order to improve the system. Click on the feedback button, your name and email are optional. You do NOT have to copy your queries into the comments since we will get them automatically:<\/p>\n
      \"\"<\/p>\n
      Spread the word!<\/strong><\/p>\n
      Please help us spread the word on this great tool, the only one on the web that will convert Access queries to TSQL, blog, tweet and mention on LinkedIn!<\/p>\n
      This amazing tool is based on the work of Aaron Kogan and Ben Sacherich, who provided guidance, help and testing to make it happen. AUG wishes to thank them both for their time, code, and efforts.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"
      I’m proud to announce a new groundbreaking tool at https:\/\/accessusergroups.org\/sql-converter\/ to help Access developers worldwide on making the transition over to SQL Server much easier. The tool will convert your Access query SQL to SQL Server’s TSQL language for easy pasting into your code or SQL Server Management Studio. Why we built this tool Those […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"mc4wp_mailchimp_campaign":[],"footnotes":""},"categories":[1],"tags":[],"yoast_head":"\nIntroducing Access to TSQL Converter + VBA Tool - AccessUserGroups.org<\/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:\/\/accessusergroups.org\/blog\/accesssqltool\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Introducing Access to TSQL Converter + VBA Tool - AccessUserGroups.org\" \/>\n<meta property=\"og:description\" content=\"I’m proud to announce a new groundbreaking tool at https:\/\/accessusergroups.org\/sql-converter\/ to help Access developers worldwide on making the transition over to SQL Server much easier. The tool will convert your Access query SQL to SQL Server’s TSQL language for easy pasting into your code or SQL Server Management Studio. Why we built this tool Those […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/accessusergroups.org\/blog\/accesssqltool\/\" \/>\n<meta property=\"og:site_name\" content=\"AccessUserGroups.org\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/AccessUserGroups\" \/>\n<meta property=\"article:author\" content=\"AccessExpert\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-17T18:54:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/accessusergroups.org\/wp-content\/uploads\/2021\/01\/VBA.jpg\" \/>\n<meta name=\"author\" content=\"Juan Soto\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@jsoto22\" \/>\n<meta name=\"twitter:site\" content=\"@AccessUserGroup\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Juan Soto\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/accessusergroups.org\/blog\/accesssqltool\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/accessusergroups.org\/blog\/accesssqltool\/\"},\"author\":{\"name\":\"Juan Soto\",\"@id\":\"https:\/\/accessusergroups.org\/#\/schema\/person\/9fce02a6788b90bc545407d6952f1ef3\"},\"headline\":\"Introducing Access to TSQL Converter + VBA Tool\",\"datePublished\":\"2021-01-17T18:54:21+00:00\",\"dateModified\":\"2021-01-17T18:54:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/accessusergroups.org\/blog\/accesssqltool\/\"},\"wordCount\":521,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/accessusergroups.org\/#organization\"},\"image\":{\"@id\":\"https:\/\/accessusergroups.org\/blog\/accesssqltool\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/accessusergroups.org\/wp-content\/uploads\/2021\/01\/VBA.jpg\",\"articleSection\":[\"Blog\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/accessusergroups.org\/blog\/accesssqltool\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/accessusergroups.org\/blog\/accesssqltool\/\",\"url\":\"https:\/\/accessusergroups.org\/blog\/accesssqltool\/\",\"name\":\"Introducing Access to TSQL Converter + VBA Tool - AccessUserGroups.org\",\"isPartOf\":{\"@id\":\"https:\/\/accessusergroups.org\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/accessusergroups.org\/blog\/accesssqltool\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/accessusergroups.org\/blog\/accesssqltool\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/accessusergroups.org\/wp-content\/uploads\/2021\/01\/VBA.jpg\",\"datePublished\":\"2021-01-17T18:54:21+00:00\",\"dateModified\":\"2021-01-17T18:54:21+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/accessusergroups.org\/blog\/accesssqltool\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/accessusergroups.org\/blog\/accesssqltool\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/accessusergroups.org\/blog\/accesssqltool\/#primaryimage\",\"url\":\"https:\/\/accessusergroups.org\/wp-content\/uploads\/2021\/01\/VBA.jpg\",\"contentUrl\":\"https:\/\/accessusergroups.org\/wp-content\/uploads\/2021\/01\/VBA.jpg\",\"width\":948,\"height\":422},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/accessusergroups.org\/blog\/accesssqltool\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/accessusergroups.org\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Introducing Access to TSQL Converter + VBA Tool\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/accessusergroups.org\/#website\",\"url\":\"https:\/\/accessusergroups.org\/\",\"name\":\"AccessUserGroups.org\",\"description\":\"Virtual Access User Groups\",\"publisher\":{\"@id\":\"https:\/\/accessusergroups.org\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/accessusergroups.org\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/accessusergroups.org\/#organization\",\"name\":\"Access User Groups\",\"url\":\"https:\/\/accessusergroups.org\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/accessusergroups.org\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/accessusergroups.org\/wp-content\/uploads\/2021\/10\/logo.png\",\"contentUrl\":\"https:\/\/accessusergroups.org\/wp-content\/uploads\/2021\/10\/logo.png\",\"width\":1011,\"height\":260,\"caption\":\"Access User Groups\"},\"image\":{\"@id\":\"https:\/\/accessusergroups.org\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/AccessUserGroups\",\"https:\/\/twitter.com\/AccessUserGroup\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/accessusergroups.org\/#\/schema\/person\/9fce02a6788b90bc545407d6952f1ef3\",\"name\":\"Juan Soto\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/accessusergroups.org\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fed15957845609db3e3202496ae80af2?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fed15957845609db3e3202496ae80af2?s=96&d=mm&r=g\",\"caption\":\"Juan Soto\"},\"description\":\"Juan Soto is a Senior Access Developer at IT Impact Inc. and a Microsoft Access MVP. He specializes in Access with SQL Server databases. His passion for Access has led him to helping a wide range of businesses in helping them establish a secure, stable and efficient environment with SQL Server. He's a frequent speaker at Access user groups nationwide and recently spoke at the Orange County SQL Saturday # 73. If you wish to have Juan speak at your next group meeting you can contact him here.\",\"sameAs\":[\"http:\/\/itimpact.com\",\"AccessExpert\",\"juansoto\",\"https:\/\/twitter.com\/jsoto22\"],\"url\":\"https:\/\/accessusergroups.org\/blog\/author\/juan-soto\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Introducing Access to TSQL Converter + VBA Tool - AccessUserGroups.org","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:\/\/accessusergroups.org\/blog\/accesssqltool\/","og_locale":"en_US","og_type":"article","og_title":"Introducing Access to TSQL Converter + VBA Tool - AccessUserGroups.org","og_description":"I’m proud to announce a new groundbreaking tool at https:\/\/accessusergroups.org\/sql-converter\/ to help Access developers worldwide on making the transition over to SQL Server much easier. The tool will convert your Access query SQL to SQL Server’s TSQL language for easy pasting into your code or SQL Server Management Studio. Why we built this tool Those […]","og_url":"https:\/\/accessusergroups.org\/blog\/accesssqltool\/","og_site_name":"AccessUserGroups.org","article_publisher":"https:\/\/www.facebook.com\/AccessUserGroups","article_author":"AccessExpert","article_published_time":"2021-01-17T18:54:21+00:00","og_image":[{"url":"https:\/\/accessusergroups.org\/wp-content\/uploads\/2021\/01\/VBA.jpg"}],"author":"Juan Soto","twitter_card":"summary_large_image","twitter_creator":"@jsoto22","twitter_site":"@AccessUserGroup","twitter_misc":{"Written by":"Juan Soto","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/accessusergroups.org\/blog\/accesssqltool\/#article","isPartOf":{"@id":"https:\/\/accessusergroups.org\/blog\/accesssqltool\/"},"author":{"name":"Juan Soto","@id":"https:\/\/accessusergroups.org\/#\/schema\/person\/9fce02a6788b90bc545407d6952f1ef3"},"headline":"Introducing Access to TSQL Converter + VBA Tool","datePublished":"2021-01-17T18:54:21+00:00","dateModified":"2021-01-17T18:54:21+00:00","mainEntityOfPage":{"@id":"https:\/\/accessusergroups.org\/blog\/accesssqltool\/"},"wordCount":521,"commentCount":2,"publisher":{"@id":"https:\/\/accessusergroups.org\/#organization"},"image":{"@id":"https:\/\/accessusergroups.org\/blog\/accesssqltool\/#primaryimage"},"thumbnailUrl":"https:\/\/accessusergroups.org\/wp-content\/uploads\/2021\/01\/VBA.jpg","articleSection":["Blog"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/accessusergroups.org\/blog\/accesssqltool\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/accessusergroups.org\/blog\/accesssqltool\/","url":"https:\/\/accessusergroups.org\/blog\/accesssqltool\/","name":"Introducing Access to TSQL Converter + VBA Tool - AccessUserGroups.org","isPartOf":{"@id":"https:\/\/accessusergroups.org\/#website"},"primaryImageOfPage":{"@id":"https:\/\/accessusergroups.org\/blog\/accesssqltool\/#primaryimage"},"image":{"@id":"https:\/\/accessusergroups.org\/blog\/accesssqltool\/#primaryimage"},"thumbnailUrl":"https:\/\/accessusergroups.org\/wp-content\/uploads\/2021\/01\/VBA.jpg","datePublished":"2021-01-17T18:54:21+00:00","dateModified":"2021-01-17T18:54:21+00:00","breadcrumb":{"@id":"https:\/\/accessusergroups.org\/blog\/accesssqltool\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/accessusergroups.org\/blog\/accesssqltool\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/accessusergroups.org\/blog\/accesssqltool\/#primaryimage","url":"https:\/\/accessusergroups.org\/wp-content\/uploads\/2021\/01\/VBA.jpg","contentUrl":"https:\/\/accessusergroups.org\/wp-content\/uploads\/2021\/01\/VBA.jpg","width":948,"height":422},{"@type":"BreadcrumbList","@id":"https:\/\/accessusergroups.org\/blog\/accesssqltool\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/accessusergroups.org\/"},{"@type":"ListItem","position":2,"name":"Introducing Access to TSQL Converter + VBA Tool"}]},{"@type":"WebSite","@id":"https:\/\/accessusergroups.org\/#website","url":"https:\/\/accessusergroups.org\/","name":"AccessUserGroups.org","description":"Virtual Access User Groups","publisher":{"@id":"https:\/\/accessusergroups.org\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/accessusergroups.org\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/accessusergroups.org\/#organization","name":"Access User Groups","url":"https:\/\/accessusergroups.org\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/accessusergroups.org\/#\/schema\/logo\/image\/","url":"https:\/\/accessusergroups.org\/wp-content\/uploads\/2021\/10\/logo.png","contentUrl":"https:\/\/accessusergroups.org\/wp-content\/uploads\/2021\/10\/logo.png","width":1011,"height":260,"caption":"Access User Groups"},"image":{"@id":"https:\/\/accessusergroups.org\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/AccessUserGroups","https:\/\/twitter.com\/AccessUserGroup"]},{"@type":"Person","@id":"https:\/\/accessusergroups.org\/#\/schema\/person\/9fce02a6788b90bc545407d6952f1ef3","name":"Juan Soto","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/accessusergroups.org\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/fed15957845609db3e3202496ae80af2?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fed15957845609db3e3202496ae80af2?s=96&d=mm&r=g","caption":"Juan Soto"},"description":"Juan Soto is a Senior Access Developer at IT Impact Inc. and a Microsoft Access MVP. He specializes in Access with SQL Server databases. His passion for Access has led him to helping a wide range of businesses in helping them establish a secure, stable and efficient environment with SQL Server. He's a frequent speaker at Access user groups nationwide and recently spoke at the Orange County SQL Saturday # 73. If you wish to have Juan speak at your next group meeting you can contact him here.","sameAs":["http:\/\/itimpact.com","AccessExpert","juansoto","https:\/\/twitter.com\/jsoto22"],"url":"https:\/\/accessusergroups.org\/blog\/author\/juan-soto\/"}]}},"_links":{"self":[{"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/posts\/1578"}],"collection":[{"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/comments?post=1578"}],"version-history":[{"count":5,"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/posts\/1578\/revisions"}],"predecessor-version":[{"id":1589,"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/posts\/1578\/revisions\/1589"}],"wp:attachment":[{"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/media?parent=1578"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/categories?post=1578"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/tags?post=1578"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}