File import to MS Access 2007

[Dan_var]

Hello,

I am trying to import both a Text file and also an Excel 2007 file into MS Access 2007. I keep getting error saying "search key not found". I deleted the first row containing Column Headers in Excel file and still the problem persists. Appreciate your help. Is there any limitations on the file size. The records in Excel is 780k lines.

thanks
dan

 

[xenou]

Sounds like a solution was found here:

http://www.accessforums.net/import-export-data/search-key-not-found-any-record-1852.html

Does that help?

ξ