neileg
AWF VIP
- Local time
- Today, 19:03
- Joined
- Dec 4, 2002
- Messages
- 5,975
I should know this, but I don't!
I want to import a list of names into a single field table. The text file looks like this:
Appleby David, Atkinson Susan, Blair Brenda, Brown Karen
So each record is terminated by a comma and a space. The import wizard expects records to be separated by a carriage return.
Obviously I can massage the data by replacing the comma and space with a CR, but surely I should be able to import the file as it stands?
I want to import a list of names into a single field table. The text file looks like this:
Appleby David, Atkinson Susan, Blair Brenda, Brown Karen
So each record is terminated by a comma and a space. The import wizard expects records to be separated by a carriage return.
Obviously I can massage the data by replacing the comma and space with a CR, but surely I should be able to import the file as it stands?