separate by newline character

  • Thread starter Thread starter DC
  • Start date Start date
D

DC

Hello,
I want to import from a txt file with a list of name
which is separated by a newline character into Access 2000.
File like this
____________________________
John
Paul
Sue
_______________________________
just a bunch of name after name in a newline

I tried to use the Get External Data function but i am
only allowed to enter a one character filed as delimiter.

Is there any hint i can accomplish this?

-dc
 
Hi DC,

If what you have is a single list of names separated by newlines, they
will import to a one-field table. Because there's only one field, the
field separator character ("delimiter") won't appear so it doesn't
matter what you tell Access it is.

If on the other hand you have a list of lists of names, with each name
separated by a newline and each list separated by a blank line (i.e. two
newlines in succession), you need to think about your database
structure.

For instance, are these just lists of names (e.g. one list contains
John, Paul, Sue; another contains Fred, John, Paul, Peter, Sue; and
another Amy, Fred, Peter, Teresa).

Does the number of names differ from list to list?

Or is the data more structured than that (e.g.
John
Paul
Sue
means
John - Captain
Paul - First Officer
Sue - Purser
)?

Please post back with more information.
 
Back
Top