import of data from a txt-file

[Guest]

Dear experts,

I have problems in transferring data to the data-base. I import a
three-column txt-file (columns separated by tabs), which is already in
normalized form, i.e. many entries in any of the columns appear more often
than once, only the corresponding data in the next column changes. ACCESS now
often performs typographic corrections automatically or detects empty
data-cells, although there are no mistakes or voids. In the txt-file
sometimes just one letter changes (chemical systems), so that the entries may
sometimes seem similar to each other.
Given the txt-file is correct and normalized, how can I suppress these
failings?

Thank you
Martin

 

[Douglas J Steele]

Rather than importing the text file, try linking to it. Then, create a query
that uses SELECT DISTINCT on the 3 columns in question, and use that as the
basis for a Make Table query that populates the data into a table in your
database.