When I import a text file with fields separated by ~ character, if I have a field with blanks, the field in the table appears as null. Also if I have valid characters in the text field plus some spaces at the end, it will trim out those spaces.
I need access to import the field just as it is, respecting any blanks. The field es defined as text. Is there some option I need to set up ? looks like its doing an auto trim. Mi version es Access 2003.
Please help !