Import CSV file problem

[gg80]

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.

[ItsMe]

It has been a while since I ran the wizard but... Since it is a new table why not let Access create a Primary Key for you? If I recall correctly, it will build an autonumber column for you separate from the data being imported.

[ssanfu]

Can you provide a CSV file that demonstrates the problem? I've never seen that error message.

[gg80]

OYC_T009481331.zip

I think that I have attached it. If not, let me know and I will try again. This procedure seems not as clear as it once was.

[ssanfu]

The CSV file is not in the correct format. When I tried to do the import in Access, the import routine saw 16 fields after the field "JS03"; these fields were actually data.

The line separator is displayed as a box when viewed in Notepad. If I open the CSV file in Excel or Wordpad, then save it back out as CSV, the new field can be imported with no errors. (I did change some of the field types that Access selected to Text).

So the CSV file format has formatting errors. I think the newline char is a tab char.... but this is just a guess.
See attached CSV file that I saved using Excel to see the differences (Open using Notepad.)

Try importing the attached file....

[gg80]

I tried your file and the Wizard imported with no problems.

The source who sets his site up for downloading his CSV file does his design with an Apple computer, which maybe source of problem. I have imported in past with an older version of my Access program with no problems, but it has been a while.

I really appreciate your quick response and the fact that you have given me a definition of the problem This has been very frustrating. Thank you again . FYI, I will let you know what I learn from source of the csv file.

[gg80]

The CSV creator modified the file and uploads ok now. I attached FYI. I'm still not clear why the old format worked fine with older versions of my program. Thanks again for help.


OYC_T007869653Newer2.zip