Importing CSV file (problem with name)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sarah - 31 Aug 2004 16:23 GMT

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

Reply to this Message

Lynn Trapp - 31 Aug 2004 16:53 GMT

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.

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

> Hi All-
>
[quoted text clipped - 7 lines]
>
> Thanks

Reply to this Message