Topics: can anybody help me on my biology homework i dont understand it?
When importing from a csv file, I have a field that is a raw phone number. 10 digits no spaces or special characters. No mater what I do this will not import. If I only have 9 digits, it imports fine. Add the extra digit, and error returns! Very frustrated!!! What is the issue. Can anyone help with this?
Do the same above the steps “Choose the same file BUT choose Append a copy of the records to the table - Click OK” you listed in your last reply.
When running the wizard and importing into an existing data base, Access is automatically choosing the field types for me, and then converting to my designated file type. In the fields that I am having issues with, it is choosing Long Integer, which will not convert correctly. I need Access to import this field as text. How do I get Access to import the fields with my field type designation?