{"id":65137,"date":"2019-11-01T11:04:07","date_gmt":"2019-11-01T11:04:07","guid":{"rendered":"http:\/\/www.accessrepairnrecovery.com\/blog\/?p=65137"},"modified":"2021-07-17T04:56:45","modified_gmt":"2021-07-17T04:56:45","slug":"ms-access-import-error","status":"publish","type":"post","link":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error","title":{"rendered":"Fixes To Resolve MS Access Import Errors"},"content":{"rendered":"<div class=\"8e1a49907eb0ebe2b39ac6355e555698\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">Importing data to or from the Access database is a little dicey task to perform. Encountering import errors meanwhile the import process complicates the process more. Mainly if this leads to data loss then losing a single piece of data is not acceptable.<\/p>\n<p style=\"text-align: justify;\">If you are facing this <strong>MS Access import error<\/strong> while working with few records. Then tasks of entering data manually and missing value is not a big deal.<\/p>\n<p style=\"text-align: justify;\">Moreover, if the <strong>Microsoft Access import errors<\/strong> drop thousands of values then you must get into a problem.<\/p>\n<p style=\"text-align: justify;\">So, before the problem gets too complicated it\u2019s better to <strong>fix MS Access import errors. <\/strong>Here in this post, we will discuss some commonly encountered <strong>Access database import errors<\/strong> and ways to resolve such import errors.<!--more--><\/p>\n<h2 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><strong>How To Fix Import Errors In Access?<\/strong><\/span><\/h2>\n<p>In this section, we will discuss 3 different <strong>Access import errors and their fixes.<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><a href=\"#a1\">Error 1: Fix MS Access Error Importing Excel File<\/a><\/strong><\/p>\n<p style=\"text-align: justify;\"><a href=\"#a2\"><strong>Error 2: Fix Import Specification Error in Microsoft Access<\/strong><\/a><\/p>\n<p style=\"text-align: justify;\"><strong><a href=\"#a3\">Error 3: Fix Microsoft Access Import Truncation error<\/a><\/strong><\/p>\n<p><a name=\"a1\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong><span style=\"text-decoration: underline;\">Error 1: Fix MS Access Error Importing Excel File<\/span><\/strong><\/h3>\n<p style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Symptoms<\/strong><\/span><\/p>\n<p style=\"text-align: justify;\">It is seen Access encounters export\/import errors while using the Excel *.xlsx, .xls file. The problem mainly occurs when the cells contain data above 8224 bytes.<\/p>\n<p style=\"text-align: justify;\">Take a look over the error that displayed during <strong>MS Access error importing excel file.<\/strong><\/p>\n<p style=\"text-align: justify;\">Import Error: The wizard is unable to access information in the file <em>&#8216;&lt;filename&gt;&#8217;<\/em>. Please check that the file exists and is in the correct format.<\/p>\n<p style=\"text-align: justify;\">Export Error: External table is not in the expected format.<\/p>\n<p style=\"text-align: justify;\"><strong><span style=\"text-decoration: underline;\">Cause<\/span><\/strong><\/p>\n<p style=\"text-align: justify;\">The main reason behind this issue originates after the release of Access 2010 Service Pack 1. This prevents MS Access application to open an already existing Excel*.xlxs file having cell data higher than 8224 bytes.<\/p>\n<p style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Resolution<\/strong><\/span><\/p>\n<p style=\"text-align: justify;\">Try the following manual methods to <strong>fix MS Access error importing Excel file.<\/strong><\/p>\n<ol style=\"text-align: justify;\">\n<li>Make use of the *.xlsx format<\/li>\n<li>keep all the long\/memo text fields size under 8224 bytes<\/li>\n<li>If you are exporting, deleting the already existing .xls file right before doing the export task with the same name as the file.<\/li>\n<li>Now open up your .xls file before starting the export\/import process from Access.<\/li>\n<\/ol>\n<p><a name=\"a2\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\">Error 2: <\/span><span style=\"text-decoration: underline;\"><strong>Fix Import Specification Error in Microsoft Access<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">Well, there are some <strong>Microsoft Access import errors<\/strong> that are quite frustrating and seem like a puzzle-solving task to debug. Among those error one very frequently encountered <strong>Access import error <\/strong>is:<\/p>\n<blockquote><p><strong><span style=\"color: #ff0000;\"><em>\u201cRun-Time error \u20183625\u2019: The text file specification \u2018My Saved Access Import Spec\u2019 does not exist. You cannot import, export, or link using that specification.\u201d<\/em><\/span><\/strong><\/p>\n<p>OR<\/p>\n<p><strong><span style=\"color: #ff0000;\">an error occurred trying to save import\/export specification<\/span><\/strong><\/p><\/blockquote>\n<p style=\"text-align: justify;\">Most probably you must have to get confused between the previously saved \u201cimport steps\u201d set with \u201c<strong>import\/export specification<\/strong>\u201d. Meanwhile using the <strong><em>Docmd.TransferText<\/em>\u00a0command<\/strong>.<\/p>\n<p style=\"text-align: justify;\">You need to consider the below mentioned VBA code sample which makes use of the <em>Docmd.TransferText<\/em> command for importing a delimited file (from the stored path having string variable name strInputFileName) right within a table named \u201ctbl_Access_Import_Data\u201d making use of import specification.<\/p>\n<blockquote><p><em>Private Sub cmd_Import_Table_Click()<\/em><\/p>\n<p><em>Dim strInputFileName As String<\/em><br \/>\n<em>&#8216;Set Path to Local CSV File. This file will be imported into an Access Table.<\/em><br \/>\n<em>strInputFileName = &#8220;C:\\Users\\Desktop\\Access Data\\Access_Import_Data&#8221;<\/em><\/p>\n<p><em>&#8216; Use a Macro to Import a delimited file<\/em><br \/>\n<em>&#8216; &#8220;My Saved Access Import Spec&#8221; = Import Spec<\/em><br \/>\n<em>&#8216; &#8220;tbl_Access_Import_Data&#8221; = Destination Access Table<\/em><br \/>\n<em>&#8216; strInputFileName = hardcoded path to source csv file<\/em><\/p>\n<p><em>DoCmd.TransferText acImportDelim, &#8220;My Saved Access Import Spec&#8221;, &#8220;tbl_Access_Import_Data&#8221;, strInputFileName<\/em><\/p>\n<p><em>End Sub<\/em><\/p><\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-65221\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-1.png\" alt=\"MS Access Import Errors 1\" width=\"733\" height=\"345\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-1.png 733w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-1-300x141.png 300w\" sizes=\"auto, (max-width: 733px) 100vw, 733px\" \/><\/p>\n<p style=\"text-align: justify;\">You need to save \u201cimport steps\u201d and after then try to reference this saved \u201cimport steps\u201d along with the method <em>Docmd.TransferText.<\/em><\/p>\n<p>As you can\u2019t reference \u201cimport steps\u201d only with \u201cImport\/Export specifications\u201d.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-65222\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-2.png\" alt=\"MS Access Import Errors 2\" width=\"730\" height=\"519\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-2.png 730w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-2-300x213.png 300w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/p>\n<p style=\"text-align: justify;\">Make use of the Wizard &#8220;Import Text&#8221;\u00a0 for defining and delimiting the columns within an already specified .csv file. In the above figure, I have also highlighted the table in which my data gets imported. After then press the <strong>Finish <\/strong>option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-65223\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-3.png\" alt=\"MS Access Import Errors 3\" width=\"730\" height=\"552\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-3.png 730w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-3-300x227.png 300w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/p>\n<p style=\"text-align: justify;\">After tapping the<strong> Finish<\/strong> option. On the next screen, you have to save the import steps which are defined previously.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-65224\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-4.png\" alt=\"MS Access Import Errors 4\" width=\"730\" height=\"535\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-4.png 730w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-4-300x220.png 300w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/p>\n<p style=\"text-align: justify;\">I have saved the \u201cimport step\u201d by mistakenly with the name \u201cMy Saved Access Import Spec\u201d. Well at this time the name is according to the value which is erroneously moved to method <em>Docmd.TransferText <\/em>in code.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-65225\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-5.png\" alt=\"MS Access Import Errors 5\" width=\"730\" height=\"344\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-5.png 730w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-5-300x141.png 300w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/p>\n<p style=\"text-align: justify;\">This results in fixing the \u2018Run-time error 3625\u2019.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-65226\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-6.png\" alt=\"MS Access Import Errors 6\" width=\"730\" height=\"517\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-6.png 730w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-6-300x212.png 300w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/p>\n<p style=\"text-align: justify;\">For saving the legitimate Export\/import specification which is perfectly referenced with <em>Docmd.TransferText<\/em>\u00a0method. After entering into the last window of <strong>Import Text Wizard<\/strong> hit to the <strong>\u201cAdvanced\u201d<\/strong> button right before tapping to the <strong>\u201cFinish\u201c option<\/strong>.<\/p>\n<p style=\"text-align: justify;\">Tap to the \u201cSave As\u201d option (Step 2 above) present on the right side of your Windows.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-65227\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-7.png\" alt=\"MS Access Import Errors 7\" width=\"730\" height=\"458\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-7.png 730w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-7-300x188.png 300w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/p>\n<p style=\"text-align: justify;\">Assign a name and after then save your right Import\/Export specification name. Now tap to the \u201cOK\u201d option.<\/p>\n<p style=\"text-align: justify;\">If you are encountering the same window every time then you can press the \u201cSpecs\u2026\u201d button. For seeing the name of all previously saved Export\/Import specifications.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-65228\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-8.png\" alt=\"MS Access Import Errors 8\" width=\"730\" height=\"458\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-8.png 730w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-8-300x188.png 300w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/p>\n<p style=\"text-align: justify;\">In the above-shown figure, I have only one Export\/Import specification having the name <strong>\u201cMy Real Saved Access Import Spec\u201d.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-65229\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-9.png\" alt=\"MS Access Import Errors 9\" width=\"730\" height=\"375\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-9.png 730w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/MS-Access-Import-Errors-9-300x154.png 300w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/p>\n<p style=\"text-align: justify;\">Once the right Export\/Import specification gets the reference in the VBA Code. This will execute the code as intended.<\/p>\n<p><a name=\"a3\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong><span style=\"text-decoration: underline;\">Error 3: <\/span><span style=\"text-decoration: underline;\">Fix Microsoft Access Import Truncation error<\/span><\/strong><\/h3>\n<p style=\"text-align: justify;\">If you are trying to import table to Access from any file and you are getting \u201cImportErrors\u201d in your created table\/report. Then the chances must be that your table is not imported correctly.<\/p>\n<h4 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Causes Behind Import Truncation Error<\/strong><\/span><\/h4>\n<p style=\"text-align: justify;\">Let\u2019s know why you are getting this MS Access Import Error Field Truncation.<\/p>\n<p style=\"text-align: justify;\">I caught this issue when I was trying to import a .dat file and converting it to an Access table.<\/p>\n<p style=\"text-align: justify;\">At the time of importing in Access, I have noticed that it fails to import some fields due to encountrance of error. Along with that, it notified you of the field which you need to fix for \u201cImportErrors\u201d in the table\/report.<\/p>\n<p style=\"text-align: justify;\">Open the freshly created table to check which thing is actually taking issue with the import.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-65232\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/Microsoft-Access-import-Truncation-error.png\" alt=\"Microsoft Access import Truncation error\" width=\"750\" height=\"195\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/Microsoft-Access-import-Truncation-error.png 750w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/Microsoft-Access-import-Truncation-error-300x78.png 300w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/p>\n<h4 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Import error table:<\/strong><\/span><\/h4>\n<p style=\"text-align: justify;\">In the figure you can see there are 3 columns:<\/p>\n<p style=\"text-align: justify;\"><strong>Error:<\/strong>\u00a0this column contains error encountered in File Import<br \/>\n<strong>Field:<\/strong>\u00a0This column has the Field Name where the error occurs<br \/>\n<strong>Row:<\/strong>\u00a0it indicates the row number in which error is encountered.<\/p>\n<p style=\"text-align: justify;\">In the shown table you can see that in the first row we have \u201cfield truncation\u201d error for row number and field name. through this table shown in the figure, you will get all information needed for searching the content of that row.<\/p>\n<h4 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Truncation<\/strong><\/span><\/h4>\n<p style=\"text-align: justify;\"><strong>MS Access Import Error Field Truncation<\/strong> occurs when the variable type is not that big to keep the data assigned to it. The fact is different variable type covers the different length and data type.<\/p>\n<p style=\"text-align: justify;\">In the above-discussed case datatype for \u201cCC\u201d is the \u201cText\u201d variable. This text variable has the maximum capacity of holding 255 characters.<\/p>\n<table width=\"750\">\n<tbody>\n<tr>\n<td><strong>Data Type<\/strong><\/td>\n<td><strong>Description<\/strong><\/td>\n<\/tr>\n<tr>\n<td>Text<\/td>\n<td>Maximum capacity of holding 255 characters (numbers and text)<\/td>\n<\/tr>\n<tr>\n<td>Memo<\/td>\n<td>Maximum capacity of holding 65,536 characters (numbers and text)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\">So, to resolve the above issue, the data type of field \u201cCC\u201d which is \u201cText\u201d must be changed to the \u201cMemo\u201d data type. Do this before ending up the importing task.<\/p>\n<p style=\"text-align: justify;\">You all must be thinking that memo data type should be used everywhere for resolving the MS Access import truncation error.<\/p>\n<p style=\"text-align: justify;\">So, let me clear this to you that use this memo data type only when working with a huge amount of data.<\/p>\n<p style=\"text-align: justify;\">In the latest version of MS Access, there are two types of data types \u201cShort Text\u201d and \u201cText\u201d.<\/p>\n<p style=\"text-align: justify;\">To make changes of datatype follow the steps mentioned here:<\/p>\n<ul style=\"text-align: justify;\">\n<li>In the\u00a0<strong>File<\/strong>-&gt;\u00a0<strong>Import<\/strong> screen:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-65233\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/Microsoft-Access-import-Truncation-error-1.png\" alt=\"Microsoft Access import Truncation error 1\" width=\"490\" height=\"388\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/Microsoft-Access-import-Truncation-error-1.png 490w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/Microsoft-Access-import-Truncation-error-1-300x238.png 300w\" sizes=\"auto, (max-width: 490px) 100vw, 490px\" \/><\/p>\n<h4 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Import Text Wizard<\/strong><\/span><\/h4>\n<ul style=\"text-align: justify;\">\n<li>Tap to the <strong>\u201cAdvanced\u201d<\/strong> button present on the left bottom. This will open the following screen.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-65234\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/Microsoft-Access-import-Truncation-error-2.png\" alt=\"Microsoft Access import Truncation error 2\" width=\"467\" height=\"409\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/Microsoft-Access-import-Truncation-error-2.png 467w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/Microsoft-Access-import-Truncation-error-2-300x263.png 300w\" sizes=\"auto, (max-width: 467px) 100vw, 467px\" \/><\/p>\n<h4 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Import Specification<\/strong><\/span><\/h4>\n<p style=\"text-align: justify;\">Now, you need to look for the <strong>\u201cField Name\u201d<\/strong> of <strong>\u201cCC\u201d<\/strong> and change the <strong>\u201cData Type\u201d<\/strong> to <strong>\u201cMemo\u201d<\/strong>. If necessary, change all other fields&#8217; data types too. After doing this when you import this file, you won\u2019t get any truncation error.<\/p>\n<h3 style=\"text-align: justify;\"><strong><span style=\"text-decoration: underline;\">How To Avoid Import Errors In Access?<\/span><\/strong><\/h3>\n<p style=\"text-align: justify;\">Here are some techniques I&#8217;ve learned over the years on <strong>how to avoid import errors in Access.<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>If in your access application you are using TextTransfermethod for importing CSV file. after the import process Access skip or around your values. Add this line right above the line where you have call action TextTransfer:<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>[YourSourceFile.txt].[YourColumn].numberformat = &#8220;@&#8221;<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>If the field having problem contains the monetary values like dollars. Try to change the data type to double or integer.<\/li>\n<li>If the source file contains the dates in a short format like this 15-Nov-2017, but your Access application always considers this in a long format 11\/15\/2017 0:00:00. In that case, you need to make a query having calculated fields that format.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>For example:<\/strong><\/p>\n<p style=\"text-align: justify;\">ExpDate: Format([YourDateField], &#8220;Short Date&#8221;)<\/p>\n<ul style=\"text-align: justify;\">\n<li>If you are having a source data in a text file format that MS Access application refuses for importing. Then make use of Access application for establishing an ODBC connection with the file. For this, you need to create a new data source in Windows. After then select <strong><em>Microsoft Text Driver <\/em><\/strong>as <strong>ODBC driver<\/strong>.<\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><strong><u>Go The Professional Recommended Solution:<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">Meanwhile, the MS Access import error if you lost up your MS Access table, report, or any other object. Then you can get it back by using <strong><a href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/get-access-file-repair-tool\" target=\"_blank\" rel=\"noopener noreferrer\">MS Access Repair Tool<\/a>.<\/strong> With this professional software, you can easily fix corrupt, damaged, or inaccessible Access database. Apart from this, the tool is also very helpful to restore your corrupt tables, indexes, queries, and relations.<\/p>\n<p style=\"text-align: justify;\"><center><a href='https:\/\/www.accessrepairnrecovery.com\/blog\/get-access-file-repair-tool' target='_blank'><img src='https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2020\/06\/en-dwn-btn.jpg' \/><\/a><p style='font-size:11px;'><font color='red'><b>*<\/b><\/font> By clicking the Download button above and installing Stellar Repair for Access (14.8 MB), I acknowledge that I have read and agree to the <a href='https:\/\/www.accessrepairnrecovery.com\/eula.php' target='_blank'>End User License Agreement<\/a> and <a href='https:\/\/www.accessrepairnrecovery.com\/privacy-policy.php' target='_blank'>Privacy Policy<\/a> of this site.<\/p><\/center>\n<p style=\"text-align: justify;\">The powerful algorithm of this tool efficiently scans severely corrupted Access database files. And it&#8217;s highly interactive GUI interface helps the user to easily repair Access database without hampering the original structure of the file. You can also recover the password-protected forms or modules and many more.<\/p>\n<p style=\"text-align: justify;\">A free trial version is available that you can install to check the features and reliability of the software. This tool can easily fix all minor \/major database errors and problems occurred in MS <strong>Access 2019, 2016, 2013, 2010, 2007, 2003, 2002, 2000<\/strong> on almost all version of Windows operating system such as <strong>Windows 8\/7\/Vista\/XP\/2003<\/strong>.<\/p>\n<h2 style=\"text-align: justify;\"><strong><span style=\"text-decoration: underline;\">Wrap Up:<\/span><\/strong><\/h2>\n<p style=\"text-align: justify;\">Managing data properly before starting up the importing process can significantly diminish the issue. Try all the aforementioned fixes to resolve any kind of issues related to <strong>MS Access import error.<\/strong><\/p>\n<p style=\"text-align: justify;\"><div style='margin: 8px 0; clear: both;'><div style='border: 1px solid #e7e7e7; border-radius: 3px; background: #ffffff; color: #000; margin-top: 30px;'><div style='display: inline; background: #fff; padding: 10px; border: 1px solid #e7e7e7; border-bottom-right-radius: 10px; border-top-left-radius: 10px; border-top-right-radius: 10px; margin-left: -1px;'><img src='https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/12\/y-bulb.png' alt='tip' style='vertical-align: middle;' width='30px'><strong style='font-size: 18px; vertical-align: middle;'> Still having issues?<\/strong> Fix them with this Access repair tool: <\/div><div style='padding: 1rem; line-height: 1.6;'><p style='margin: 0; font-size: 17px;'>This software repairs & restores all ACCDB\/MDB objects including tables, reports, queries, records, forms, and indexes along with modules, macros, and other stuffs effectively.<\/p><div><ol style='font-size: 17px;'><li><strong><a href='https:\/\/www.accessrepairnrecovery.com\/blog\/get-access-file-repair-tool' target='_blank'>Download Stellar Repair for Access <\/a><\/strong> rated <i>Great<\/i> on Cnet (<i>download starts on this page<\/i>).<\/li><li>Click <strong>Browse<\/strong> and <strong>Search<\/strong> option to locate corrupt Access database.<\/li><li>Click <strong>Repair<\/strong> button to repair & preview the database objects.<\/li><\/ol><\/div><\/div><\/div><\/div>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Importing data to or from the Access database is a little dicey task to perform. Encountering import errors meanwhile the &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Fixes To Resolve MS Access Import Errors\" class=\"read-more button\" href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error#more-65137\" aria-label=\"Read more about Fixes To Resolve MS Access Import Errors\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":65143,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1021],"tags":[1223,1224,1225,1226,1227,1228,1229,1230,1231,1222,1232],"class_list":["post-65137","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-fix-errors","tag-access-table-import-errors","tag-microsoft-access-import-errors","tag-ms-access-error-importing-excel-file","tag-ms-access-import-error-cannot-open-database","tag-ms-access-import-error-field-truncation","tag-ms-access-import-error-no-current-record","tag-ms-access-import-error-search-key-not-found-any-record","tag-ms-access-import-error-subscript-out-of-range","tag-ms-access-import-error-type-conversion-failure","tag-ms-access-import-errors","tag-ms-access-turn-off-import-errors","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Fixes To Resolve MS Access Import Errors<\/title>\n<meta name=\"description\" content=\"Try out the fixes to resolve MS Access import errors. Like, MS Access error importing excel file, MS Access import error field truncation etc.\" \/>\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.accessrepairnrecovery.com\/blog\/ms-access-import-error\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fixes To Resolve MS Access Import Errors\" \/>\n<meta property=\"og:description\" content=\"Try out the fixes to resolve MS Access import errors. Like, MS Access error importing excel file, MS Access import error field truncation etc.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error\" \/>\n<meta property=\"og:site_name\" content=\"MS Access Repair And Recovery Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-01T11:04:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-17T04:56:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/import-error.png\" \/>\n\t<meta property=\"og:image:width\" content=\"850\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Pearson Willey\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pearson Willey\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error\"},\"author\":{\"name\":\"Pearson Willey\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb\"},\"headline\":\"Fixes To Resolve MS Access Import Errors\",\"datePublished\":\"2019-11-01T11:04:07+00:00\",\"dateModified\":\"2021-07-17T04:56:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error\"},\"wordCount\":1721,\"publisher\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/import-error.png\",\"keywords\":[\"access table import errors\",\"Microsoft access import errors\",\"MS Access Error Importing Excel File\",\"ms access import error cannot open database\",\"ms access import error field truncation\",\"ms access import error no current record\",\"ms access import error search key not found any record\",\"ms access import error subscript out of range\",\"ms access import error type conversion failure\",\"ms access import errors\",\"ms access turn off import errors\"],\"articleSection\":[\"Fix Access Errors\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error\",\"name\":\"Fixes To Resolve MS Access Import Errors\",\"isPartOf\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/import-error.png\",\"datePublished\":\"2019-11-01T11:04:07+00:00\",\"dateModified\":\"2021-07-17T04:56:45+00:00\",\"description\":\"Try out the fixes to resolve MS Access import errors. Like, MS Access error importing excel file, MS Access import error field truncation etc.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error#primaryimage\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/import-error.png\",\"contentUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/import-error.png\",\"width\":850,\"height\":450,\"caption\":\"Fixes To Resolve MS Access Import Errors\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fixes To Resolve MS Access Import Errors\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#website\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/\",\"name\":\"MS Access Repair And Recovery Blog\",\"description\":\"Your One Stop Destination for MS Access Fixes, Tutorials &amp; More\",\"publisher\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization\",\"name\":\"MS Access Repair And Recovery Blog\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png\",\"contentUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"MS Access Repair And Recovery Blog\"},\"image\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb\",\"name\":\"Pearson Willey\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g\",\"caption\":\"Pearson Willey\"},\"description\":\"Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access &amp; sharing tech blogs.\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/author\/pearson-willey\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fixes To Resolve MS Access Import Errors","description":"Try out the fixes to resolve MS Access import errors. Like, MS Access error importing excel file, MS Access import error field truncation etc.","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.accessrepairnrecovery.com\/blog\/ms-access-import-error","og_locale":"en_US","og_type":"article","og_title":"Fixes To Resolve MS Access Import Errors","og_description":"Try out the fixes to resolve MS Access import errors. Like, MS Access error importing excel file, MS Access import error field truncation etc.","og_url":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error","og_site_name":"MS Access Repair And Recovery Blog","article_published_time":"2019-11-01T11:04:07+00:00","article_modified_time":"2021-07-17T04:56:45+00:00","og_image":[{"width":850,"height":450,"url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/import-error.png","type":"image\/png"}],"author":"Pearson Willey","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Pearson Willey","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error#article","isPartOf":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error"},"author":{"name":"Pearson Willey","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb"},"headline":"Fixes To Resolve MS Access Import Errors","datePublished":"2019-11-01T11:04:07+00:00","dateModified":"2021-07-17T04:56:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error"},"wordCount":1721,"publisher":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error#primaryimage"},"thumbnailUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/import-error.png","keywords":["access table import errors","Microsoft access import errors","MS Access Error Importing Excel File","ms access import error cannot open database","ms access import error field truncation","ms access import error no current record","ms access import error search key not found any record","ms access import error subscript out of range","ms access import error type conversion failure","ms access import errors","ms access turn off import errors"],"articleSection":["Fix Access Errors"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error","name":"Fixes To Resolve MS Access Import Errors","isPartOf":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error#primaryimage"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error#primaryimage"},"thumbnailUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/import-error.png","datePublished":"2019-11-01T11:04:07+00:00","dateModified":"2021-07-17T04:56:45+00:00","description":"Try out the fixes to resolve MS Access import errors. Like, MS Access error importing excel file, MS Access import error field truncation etc.","breadcrumb":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error#primaryimage","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/import-error.png","contentUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/import-error.png","width":850,"height":450,"caption":"Fixes To Resolve MS Access Import Errors"},{"@type":"BreadcrumbList","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-import-error#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.accessrepairnrecovery.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Fixes To Resolve MS Access Import Errors"}]},{"@type":"WebSite","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#website","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/","name":"MS Access Repair And Recovery Blog","description":"Your One Stop Destination for MS Access Fixes, Tutorials &amp; More","publisher":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.accessrepairnrecovery.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization","name":"MS Access Repair And Recovery Blog","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png","contentUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png","width":350,"height":70,"caption":"MS Access Repair And Recovery Blog"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb","name":"Pearson Willey","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g","caption":"Pearson Willey"},"description":"Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access &amp; sharing tech blogs.","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/author\/pearson-willey"}]}},"_links":{"self":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/65137","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/comments?post=65137"}],"version-history":[{"count":0,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/65137\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/media\/65143"}],"wp:attachment":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/media?parent=65137"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/categories?post=65137"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/tags?post=65137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}