Import Text file to Access 2007

[ginniboo]

I have a database created in Access 2000 that I'm trying to import a text file using a designated "Specification". When I try to import to an Existing Table in Access 2007 I don't have the option to choose "No primary key".

Any ideas?

Thanks

 

[Remou]

You will not get this option when you are importing to an existing table. What did you wish to do?

 

[ginniboo]

I guess my primary question is....how do I get my existing queries in Access 2000 to work the same in 2007? My Append queries will not work by importing into an existing table or trying to Append from another table in the same database. Any good suggestions for working with Access 2007?