Importing CSV file (problem with name)

  • Thread starter Thread starter Sarah
  • Start date Start date
S

Sarah

Hi All-

I sure hope someone can offer assistance to a novice.

I have to import a CSV file of customer names. The CSV
file has the customer name as one field. The table it's
importing to requires Last name and First to be separated.
I've tried manually entering a comma between and saving as
a txt file but the import doesn't achieve my goal.

Thanks
 
You may need to import the CSV file into another table that has the names in
a single field and, then, parse it out in a query to separate the names and
append that to your other table.
 
Back
Top