Importing a text file

[MValentine]

I am using the import text wizard to import a text file to be a new table in
my database. My columns have been defined. However when I select "Finish" I
get the following message:
"The search key was not found in any record".
What is this telling me and how do I correct my problem?

Thanks for any help

 

[Jerry Whittle]

You may have a corrupt database.

Tony Toews has an excellent web page on database corruption.
Http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
Http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database.
Click on "Whittle, Jerry" on this page:
http://www.rogersaccesslibrary.com/forum/default.asp?C=1

 

[tighe]

Also, check to make sure the import file data matches the tables datatype for
all fields.

 

[MValentine]

The imported text file will create the first table of the database. I just
tried again in a new database and received the following:
The Microsoft Jet database could not find the object ". Make sure the object
exist and that you spell its name and path name correctly.

 

[MValentine]

I should add that I am using the Fixed Width option when trying to import the
text file. I have found that if I select Delimited and select Space or one of
the other options it will import but the data columns will not be correct