Importing CSV file (problem with name)

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
 
L

Lynn Trapp

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with access acImportDelim importing csv with headers 1
Import fields from .csv with variable column structure 4
Importing what file name? 3
import csv conversion & import spec error 1
Add .csv File Name When Importing Multiple Files Into a Table 0
Access Importing csv daily files into access 2007 1
Unparsable Record 1
CSV Import with duplicate field names 3

Top