I need to import a text file that has 110 fields. I make a custom specification with all of the fields and when I save it Access truncates everything after the 42nd field. Is there a limited number of fields that can be imported or am I doing something wrong?
Thanks,
Michelle
I have to append 2 fields together but before I do that I need to append spaces to the end of the 1st field to ensure its length is 15 characters. And the 2nd field needs to be 10 characters and therefore it may need spaces too. I can use spaces or the @ symbol as the place holder. For...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.