<div>
I would try a couple of things here:<br />
<br />
1) Try importing the file into a new (blank) database.<br />
2) Create the table manually, and then try importing the data into the existing table.<br />
3) Try one of the solutions mentioned here: <a href="http://www.utteraccess.com/forums/showflat.php?Board=83&Number=249362" rel="ugc">http://www.utteraccess.com/forums/showflat.php?Board=83&Number=249362</a>
</div>


I would try a couple of things here:

1) Try importing the file into a new (blank) database.
2) Create the table manually, and then try importing the data into the existing table.
3) Try one of the solutions mentioned here: http://www.utteraccess.com/forums/showflat.php?Board=83&Number=249362 [http://www.utteraccess.com/forums/showflat.php?Board=83&Number=249362]

<div>
Thanks, guys. &nbsp;These are good suggestions. &nbsp;I'll try them and let you know.
</div>


Thanks, guys.  These are good suggestions.  I'll try them and let you know.

<div>
How cool is that! &nbsp;Removed some leading spaces in the header and presto. &nbsp;THANKYOU so much!<br />
<br />

</div>


How cool is that!  Removed some leading spaces in the header and presto.  THANKYOU so much!



<div>
<div class="content wysiwyg-content">
I receive the error &quot;Search Key was not found in any record&quot; when I try to import records to create a new Access table. I am using Access 2007. &nbsp;I have tried compacting and repairing the database. &nbsp;I have tried cutting the data from the Excel file and pasting to a new spreadsheet. &nbsp;I have created a .txt &nbsp;file and tried to import also with no luck.<br />
<br />
Is there anything in the file that could cause this problem? &nbsp;Thanks.
</div>
</div>


I receive the error "Search Key was not found in any record" when I try to import records to create a new Access table. I am using Access 2007.  I have tried compacting and repairing the database.  I have tried cutting the data from the Excel file and pasting to a new spreadsheet.  I have created a .txt  file and tried to import also with no luck.

Is there anything in the file that could cause this problem?  Thanks.

&quot;Search Key was not found in any record&quot; Excel or TXT import to MS Access2007

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

&quot;Search Key was not found in any record&quot; Excel or TXT import to MS Access2007

"Search Key was not found in any record" Excel or TXT import to MS Access2007