I am trying to import a CSV file and I run into two problems.
One-Using the import wizard, I choose "import to create a new table" and then check off delimited, no primary key etc. When I click finish, I get a message "--would not succeed because would create duplicate values in the index, primary key, or relationships." How is this possible? The table has not even been created yet.
Two: I f I try to import it into an Access table with same column head names and all table fields set to text format, I get the "index or primary key cannot contain a null value" message.
Using A2007 with W7. Any help much much appreciated.