K
KGF
I have imported a CSV file into a an Access table, but somehow the CSV must
have had too many commas on some records because extra fields were created.
For about 20% of the records (total over 8000), the data for a certain field
is showing up in a bogus field. How can I move those pieces of data from the
bogus field back to the correct field?
Obviously, if the extra commas had been consistent this would be easy and I
could just rename the field, but as I said, it's only about 20%. It seems I
need to set up a query that determines if data is in the bogus field, and if
so, then move it into the correct field.
have had too many commas on some records because extra fields were created.
For about 20% of the records (total over 8000), the data for a certain field
is showing up in a bogus field. How can I move those pieces of data from the
bogus field back to the correct field?
Obviously, if the extra commas had been consistent this would be easy and I
could just rename the field, but as I said, it's only about 20%. It seems I
need to set up a query that determines if data is in the bogus field, and if
so, then move it into the correct field.