I am having trouble importing a column of numbers from the spreadsheet Numbers. I export the column as text; use the Text Import Wizard to place the column in the proper field of the db. The import choices are to append, which puts the column below the existing records - not good, I want the column to line up with the other fields. Or, to replace, which fills the desired field in the right place, but unfortunately erases all the other fields.
What am I doing wrong?