asked on

Access 2007 Import problem

I have a very simple .csv file that I tried to import. The only problem was in the name field there was a "," between the first and last name. I imported it any was and used the" as the text qualifer The preview of the import looked fine but when I finished the program broke the first and last name into two columns and the name of the columns were not on the proper data. Yes, I did go back and and take out the "," and it did work, but i must be doing something wrong. Any suggestions?

ASKER CERTIFIED SOLUTION

borki

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Nick67

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

OP_Zaharin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

OP_Zaharin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Serena2345

ASKER

Thanks for the help but I have done everything that you all have suggested already. And yes I did clean up my data because I had to as I said in my original staement. I don't understand why the wizard would look fine and then the acutally datatbase be so wrong. it seems I did not have this problem before 2007.

Jeffrey Coachman

Can you post a sample of the original, *unaltered* text file?

Serena2345

ASKER

I am giving everyone points for trying to help me. I cannot post unaltered data because of its proprietary nature. If I go in there an change it to take out sensitve information then it is no longer "unaltered". Thanks for you time and concern