Search results for query: *

Hi Bob, The file I am importing doesn't contain any invalid characters. The 43rd field is the same as the 42nd. I imported the file using the wizard and it imports the file with 42 fields and there are import errors? What I don't understand is when I am building the spec Access isn't...

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

That worked! Thanks for helping me out. Michelle

Roy, Thanks for the quick response! I must be applying your solution wrong becuase it isn't working. Here is what I filled into the "Update To field" in the query: left$([U6 Analog Tags].KKS & "@@@@@@@@@@@@@@@,15) & left$([U6 Analog Tags].Sigdef & "@@@@@@@@@@",10) This gave a syntax error...

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...