{"id":763,"date":"2020-05-01T22:21:47","date_gmt":"2020-05-01T22:21:47","guid":{"rendered":"http:\/\/www.vbastring.com\/blog\/?p=763"},"modified":"2020-05-01T22:33:38","modified_gmt":"2020-05-01T22:33:38","slug":"how-to-convert-an-access-database-to-excel-pt1","status":"publish","type":"post","link":"https:\/\/vbastring.com\/blog\/2020\/05\/01\/how-to-convert-an-access-database-to-excel-pt1\/","title":{"rendered":"How To Convert An Access Database To Excel – PT1"},"content":{"rendered":"

The IT department at most companies installs the MS Office suite on an employee’s computer without Access, but MS Access is a “specialty item”, and has to be requested as a separate install.<\/p>\n

Since some folks don’t have the Access program, but they have Excel, in this post I am going to convert my Access database into an Excel format. <\/p>\n

Using Access is much quicker and straight forward, but if you have to, you can use this method.<\/strong><\/p>\n

Note: you could have one installation of Access (paid) and then use the Access runtime (free) .<\/em><\/strong><\/p>\n

Here is my Access form:<\/p>\n

\"\"<\/a><\/p>\n

******************************
\nIn order to replicate this, I need a main form \/ sub form (datasheet) type setup.<\/p>\n

I plan to accomplish the main form with just a regular userform, and for the subform (datasheet) I will be using a listbox<\/strong>, and labels as the column headings.<\/p>\n

Then, finally, you will find out how to click on the listbox row and display the clicked item, so we can eventually open the compliance form (to do in the next tutorial).
\n*******************************<\/p>\n

Here is what the final result will look like:<\/h2>\n

\"\"<\/a><\/p>\n

First I am going to put all of the data from my database tables into worksheets in the workbook, and add a new worksheet to start from.<\/p>\n

This worksheet can be “decked out”, but I’m just going to add a “Start” button, and add a macro to it (as shown in the next few images).<\/p>\n

I’ll add an image because it’s more functional for making it visually appealing than the common “button” from the Design toolbar’s toolbox.<\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

Now add the macro to show the UserForm, and attach it to the new rectangle object<\/h2>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

Here is the image and the code for the top part of the form<\/h2>\n

\"\"<\/a><\/p>\n

'Erik Loebl\r\n'https:\/\/vbastring.com\r\n'erik@loeblcomservices.com\r\n\r\n'We will make a modular scope variable because we need this _\r\n    row reference as long as the form is open\r\n\r\nDim m_lngRow As Long\r\n\r\nPrivate Sub btnNext_Click()\r\n    Worksheets(\"Stations\").Activate\r\n        \r\n    'increment the active row and sync the UserForm and the Activesheet\r\n    'm_lngRow = ActiveCell.Row + 1\r\n    m_lngRow = m_lngRow + 1\r\n\r\n    'select the next cell and render the new data on the UserForm\r\n    \r\n    Worksheets(\"Stations\").Range(\"A\" & m_lngRow).Select\r\n    Me.txtStationID = Range(\"A\" & m_lngRow)\r\n    Me.txtStationName = Range(\"B\" & m_lngRow)\r\n    \r\n    Me.txtManagerID = Range(\"C\" & m_lngRow)\r\n    Me.txtVisitInterval = Range(\"D\" & m_lngRow)\r\n    Me.txtNextVisitDate = Range(\"E\" & m_lngRow)\r\n    \r\n    '*************************************************\r\n    'these are the inspections done at the station\r\n    '*************************************************\r\n    GetInspections (Range(\"A\" & m_lngRow))\r\n    \r\n\r\nEnd Sub\r\n\r\n\r\n\r\nPrivate Sub btnPrev_Click()\r\n    'increment the active row and sync the UserForm and the Activesheet\r\n    m_lngRow = ActiveCell.Row - 1\r\n    \r\n    If m_lngRow > 1 Then\r\n        'select the next cell and render the new data on the UserForm\r\n        Worksheets(\"Stations\").Range(\"A\" & m_lngRow).Select\r\n        Me.txtStationID = Range(\"A\" & m_lngRow)\r\n        Me.txtStationName = Range(\"B\" & m_lngRow)\r\n        \r\n        Me.txtManagerID = Range(\"C\" & m_lngRow)\r\n        Me.txtVisitInterval = Range(\"D\" & m_lngRow)\r\n        Me.txtNextVisitDate = Range(\"E\" & m_lngRow)\r\n        \r\n        '*************************************************\r\n        'these are the inspections done at the station\r\n        '*************************************************\r\n        GetInspections (Range(\"A\" & m_lngRow))\r\n    End If\r\nEnd Sub\r\n\r\n<\/pre>\n
Here is where the data for the top comes from:<\/p>\n
\"\"<\/a><\/p>\n
And here is the code for the bottom (sub) part of the form.  The information pertaining to each station.<\/h2>\n
\"\"<\/a><\/p>\n
\r\n\r\nFunction GetInspections(Arg1) As Boolean\r\n    'Purpose: Find the new cities we did business in\r\n    \r\n    Dim cnn As Object\r\n    Dim rst As Object\r\n    Dim strSQL As String\r\n    Dim lngCount As Long\r\n    \r\n    Dim strValue As String\r\n    Dim blnNew As Boolean\r\n    \r\n    Dim strDate As String\r\n\r\n    'In order to do queries with a WHERE clause, you need to name the range, otherwise use the worksheet name.\r\n\r\n    'get the new list cell value\r\n    strValue = Arg1\r\n    \r\n    If strValue = \"staID\" Or strValue = \"\" Then\r\n        'you are at the beginning or end so don't continue\r\n        Me.ListBox1.Clear\r\n        GetInspections = False\r\n    Else\r\n        'Set up the connection to the Excel worksheet\r\n        Set cnn = CreateObject(\"ADODB.Connection\")\r\n        With cnn\r\n            .Provider = \"Microsoft.ACE.OLEDB.12.0\"\r\n            .ConnectionString = \"Data Source=\" &amp; ThisWorkbook.Path &amp; \"\\\" &amp; ThisWorkbook.Name &amp; \";\" &amp; _\r\n                \"Extended Properties=\"\"Excel 12.0 Xml;HDR=YES\"\";\"\r\n            .Open\r\n        End With\r\n            \r\n        'check if that value is already one we've done business in.\r\n        strSQL = \"SELECT * FROM [SC] WHERE [sacStationID] =\" &amp; strValue\r\n        Set rst = cnn.Execute(strSQL)\r\n            \r\n        i = 0\r\n        \r\n        With Me.ListBox1\r\n            .Clear\r\n            .ColumnCount = 6\r\n            .ColumnWidths = \".5in,0in,.5in,1in,.5in,0in\"\r\n        End With\r\n        \r\n        Do Until rst.EOF\r\n            \r\n            With Me.ListBox1\r\n                .AddItem\r\n                .List(i, 0) = rst.Fields(0)\r\n                .List(i, 2) = rst.Fields(2)\r\n                .List(i, 3) = rst.Fields(3)\r\n                .List(i, 4) = rst.Fields(4)\r\n    \r\n                i = i + 1\r\n            End With\r\n    \r\n            rst.movenext\r\n        Loop\r\n        \r\n    \r\n        \r\n        rst.Close\r\n        cnn.Close\r\n        \r\n        Set rst = Nothing\r\n        Set cnn = Nothing\r\n        \r\n        GetInspections = True\r\n    End If\r\n    \r\n    \r\nEnd Function<\/pre>\n
Here is where the data for the lower form comes from:<\/p>\n
\"\"<\/a><\/p>\n
Get The Listbox Value In VBA<\/h2>\n
To see the detail about a particular compliance inspection, we need to be able to click the sub row and then show a form  based on the item that was clicked.<\/p>\n
The form is not created yet, but for illustrative purposes, here is how we are going to capture the id to pass to the compliance inspection form.<\/p>\n
\"\"<\/a><\/p>\n
Private Sub ListBox1_Click()\r\n    Dim intItems As Integer\r\n    \r\n    For intItems = 0 To ListBox1.ListCount - 1\r\n        If ListBox1.Selected(intItems) = True Then\r\n           MsgBox ListBox1.List(intItems)\r\n        End If\r\n     Next intItems\r\nEnd Sub\r\n<\/pre>\n
Stay tuned for part 2 of this.<\/p>\n
Any questions so far?  Leave them in the comments below, and share this with someone else.<\/p>\n","protected":false},"excerpt":{"rendered":"
The IT department at most companies installs the MS Office suite on an employee’s computer without Access, but MS Access is a “specialty item”, and has to be requested as a separate install. Since some folks don’t have the Access program, but they have Excel, in this post I am going to convert my Access […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","om_disable_all_campaigns":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[],"tags":[],"class_list":["post-763","post","type-post","status-publish","format-standard","hentry"],"yoast_head":"\nHow To Convert An Access Database To Excel - PT1 - My Blog<\/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:\/\/vbastring.com\/blog\/2020\/05\/01\/how-to-convert-an-access-database-to-excel-pt1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Convert An Access Database To Excel - PT1 - My Blog\" \/>\n<meta property=\"og:description\" content=\"The IT department at most companies installs the MS Office suite on an employee’s computer without Access, but MS Access is a “specialty item”, and has to be requested as a separate install. Since some folks don’t have the Access program, but they have Excel, in this post I am going to convert my Access […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vbastring.com\/blog\/2020\/05\/01\/how-to-convert-an-access-database-to-excel-pt1\/\" \/>\n<meta property=\"og:site_name\" content=\"My Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-05-01T22:21:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-05-01T22:33:38+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.vbastring.com\/blog\/wp-content\/uploads\/2020\/05\/access-form-1.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/vbastring.com\\\/blog\\\/2020\\\/05\\\/01\\\/how-to-convert-an-access-database-to-excel-pt1\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/vbastring.com\\\/blog\\\/2020\\\/05\\\/01\\\/how-to-convert-an-access-database-to-excel-pt1\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/vbastring.com\\\/blog\\\/#\\\/schema\\\/person\\\/e1de0b30e98940381697872449c341f5\"},\"headline\":\"How To Convert An Access Database To Excel – PT1\",\"datePublished\":\"2020-05-01T22:21:47+00:00\",\"dateModified\":\"2020-05-01T22:33:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/vbastring.com\\\/blog\\\/2020\\\/05\\\/01\\\/how-to-convert-an-access-database-to-excel-pt1\\\/\"},\"wordCount\":433,\"image\":{\"@id\":\"https:\\\/\\\/vbastring.com\\\/blog\\\/2020\\\/05\\\/01\\\/how-to-convert-an-access-database-to-excel-pt1\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.vbastring.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/access-form-1.png\",\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/vbastring.com\\\/blog\\\/2020\\\/05\\\/01\\\/how-to-convert-an-access-database-to-excel-pt1\\\/\",\"url\":\"https:\\\/\\\/vbastring.com\\\/blog\\\/2020\\\/05\\\/01\\\/how-to-convert-an-access-database-to-excel-pt1\\\/\",\"name\":\"How To Convert An Access Database To Excel - PT1 - My Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/vbastring.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/vbastring.com\\\/blog\\\/2020\\\/05\\\/01\\\/how-to-convert-an-access-database-to-excel-pt1\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/vbastring.com\\\/blog\\\/2020\\\/05\\\/01\\\/how-to-convert-an-access-database-to-excel-pt1\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.vbastring.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/access-form-1.png\",\"datePublished\":\"2020-05-01T22:21:47+00:00\",\"dateModified\":\"2020-05-01T22:33:38+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/vbastring.com\\\/blog\\\/#\\\/schema\\\/person\\\/e1de0b30e98940381697872449c341f5\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/vbastring.com\\\/blog\\\/2020\\\/05\\\/01\\\/how-to-convert-an-access-database-to-excel-pt1\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/vbastring.com\\\/blog\\\/2020\\\/05\\\/01\\\/how-to-convert-an-access-database-to-excel-pt1\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/vbastring.com\\\/blog\\\/2020\\\/05\\\/01\\\/how-to-convert-an-access-database-to-excel-pt1\\\/#primaryimage\",\"url\":\"http:\\\/\\\/www.vbastring.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/access-form-1.png\",\"contentUrl\":\"http:\\\/\\\/www.vbastring.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/access-form-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/vbastring.com\\\/blog\\\/2020\\\/05\\\/01\\\/how-to-convert-an-access-database-to-excel-pt1\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/vbastring.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Convert An Access Database To Excel – PT1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/vbastring.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/vbastring.com\\\/blog\\\/\",\"name\":\"My Blog\",\"description\":\"My WordPress Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/vbastring.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/vbastring.com\\\/blog\\\/#\\\/schema\\\/person\\\/e1de0b30e98940381697872449c341f5\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b2feaa698a4bd91b409df1beb5ff6acc2d7842d4f78543d413ebd468bc0171af?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b2feaa698a4bd91b409df1beb5ff6acc2d7842d4f78543d413ebd468bc0171af?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b2feaa698a4bd91b409df1beb5ff6acc2d7842d4f78543d413ebd468bc0171af?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\\\/\\\/vbastring.com\\\/blog\"],\"url\":\"https:\\\/\\\/vbastring.com\\\/blog\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Convert An Access Database To Excel - PT1 - My Blog","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:\/\/vbastring.com\/blog\/2020\/05\/01\/how-to-convert-an-access-database-to-excel-pt1\/","og_locale":"en_US","og_type":"article","og_title":"How To Convert An Access Database To Excel - PT1 - My Blog","og_description":"The IT department at most companies installs the MS Office suite on an employee’s computer without Access, but MS Access is a “specialty item”, and has to be requested as a separate install. Since some folks don’t have the Access program, but they have Excel, in this post I am going to convert my Access […]","og_url":"https:\/\/vbastring.com\/blog\/2020\/05\/01\/how-to-convert-an-access-database-to-excel-pt1\/","og_site_name":"My Blog","article_published_time":"2020-05-01T22:21:47+00:00","article_modified_time":"2020-05-01T22:33:38+00:00","og_image":[{"url":"http:\/\/www.vbastring.com\/blog\/wp-content\/uploads\/2020\/05\/access-form-1.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vbastring.com\/blog\/2020\/05\/01\/how-to-convert-an-access-database-to-excel-pt1\/#article","isPartOf":{"@id":"https:\/\/vbastring.com\/blog\/2020\/05\/01\/how-to-convert-an-access-database-to-excel-pt1\/"},"author":{"name":"admin","@id":"https:\/\/vbastring.com\/blog\/#\/schema\/person\/e1de0b30e98940381697872449c341f5"},"headline":"How To Convert An Access Database To Excel – PT1","datePublished":"2020-05-01T22:21:47+00:00","dateModified":"2020-05-01T22:33:38+00:00","mainEntityOfPage":{"@id":"https:\/\/vbastring.com\/blog\/2020\/05\/01\/how-to-convert-an-access-database-to-excel-pt1\/"},"wordCount":433,"image":{"@id":"https:\/\/vbastring.com\/blog\/2020\/05\/01\/how-to-convert-an-access-database-to-excel-pt1\/#primaryimage"},"thumbnailUrl":"http:\/\/www.vbastring.com\/blog\/wp-content\/uploads\/2020\/05\/access-form-1.png","inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/vbastring.com\/blog\/2020\/05\/01\/how-to-convert-an-access-database-to-excel-pt1\/","url":"https:\/\/vbastring.com\/blog\/2020\/05\/01\/how-to-convert-an-access-database-to-excel-pt1\/","name":"How To Convert An Access Database To Excel - PT1 - My Blog","isPartOf":{"@id":"https:\/\/vbastring.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vbastring.com\/blog\/2020\/05\/01\/how-to-convert-an-access-database-to-excel-pt1\/#primaryimage"},"image":{"@id":"https:\/\/vbastring.com\/blog\/2020\/05\/01\/how-to-convert-an-access-database-to-excel-pt1\/#primaryimage"},"thumbnailUrl":"http:\/\/www.vbastring.com\/blog\/wp-content\/uploads\/2020\/05\/access-form-1.png","datePublished":"2020-05-01T22:21:47+00:00","dateModified":"2020-05-01T22:33:38+00:00","author":{"@id":"https:\/\/vbastring.com\/blog\/#\/schema\/person\/e1de0b30e98940381697872449c341f5"},"breadcrumb":{"@id":"https:\/\/vbastring.com\/blog\/2020\/05\/01\/how-to-convert-an-access-database-to-excel-pt1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vbastring.com\/blog\/2020\/05\/01\/how-to-convert-an-access-database-to-excel-pt1\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vbastring.com\/blog\/2020\/05\/01\/how-to-convert-an-access-database-to-excel-pt1\/#primaryimage","url":"http:\/\/www.vbastring.com\/blog\/wp-content\/uploads\/2020\/05\/access-form-1.png","contentUrl":"http:\/\/www.vbastring.com\/blog\/wp-content\/uploads\/2020\/05\/access-form-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/vbastring.com\/blog\/2020\/05\/01\/how-to-convert-an-access-database-to-excel-pt1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vbastring.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How To Convert An Access Database To Excel – PT1"}]},{"@type":"WebSite","@id":"https:\/\/vbastring.com\/blog\/#website","url":"https:\/\/vbastring.com\/blog\/","name":"My Blog","description":"My WordPress Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vbastring.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/vbastring.com\/blog\/#\/schema\/person\/e1de0b30e98940381697872449c341f5","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/b2feaa698a4bd91b409df1beb5ff6acc2d7842d4f78543d413ebd468bc0171af?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b2feaa698a4bd91b409df1beb5ff6acc2d7842d4f78543d413ebd468bc0171af?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b2feaa698a4bd91b409df1beb5ff6acc2d7842d4f78543d413ebd468bc0171af?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/vbastring.com\/blog"],"url":"https:\/\/vbastring.com\/blog\/author\/admin\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/vbastring.com\/blog\/wp-json\/wp\/v2\/posts\/763","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vbastring.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vbastring.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vbastring.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vbastring.com\/blog\/wp-json\/wp\/v2\/comments?post=763"}],"version-history":[{"count":5,"href":"https:\/\/vbastring.com\/blog\/wp-json\/wp\/v2\/posts\/763\/revisions"}],"predecessor-version":[{"id":803,"href":"https:\/\/vbastring.com\/blog\/wp-json\/wp\/v2\/posts\/763\/revisions\/803"}],"wp:attachment":[{"href":"https:\/\/vbastring.com\/blog\/wp-json\/wp\/v2\/media?parent=763"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vbastring.com\/blog\/wp-json\/wp\/v2\/categories?post=763"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vbastring.com\/blog\/wp-json\/wp\/v2\/tags?post=763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}