We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Access 2007 Import problem

Serena2345
Serena2345 asked
on
Medium Priority
313 Views
Last Modified: 2012-05-11
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?
Comment
Watch Question

Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
CERTIFIED EXPERT
Most Valuable Expert 2014
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Top Expert 2011
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Top Expert 2011
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
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 CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

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

Author

Commented:
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
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.