Import text file into Access Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am a new user to Access. I am using Access 2003. I have a .txt file that
has several names of people all seperated for a ";(semicolon)". I tried to
use Access to import the .txt file, but unfortunately all the names come out
in columns instead of rows. Here is what I did, Import Text Wizard,
Delimitedk, by semicolon, in existing table. In Access, the table comes out
the following way:

John Doe John Moe Abby Fisher Fisher Price

I would like it to come out this way
John Doe
John Moe
Abby Fisher
Fisher Price

Any suggestions on how I can accomplish thins. Thanks in advance.
 
A couple of suggestion outside of Access --
Open file from Excel. Copy and paste special - transpose.
Open file in Word. Replace ; with ^p which will put each on a new
line. Save and import.
 
Back
Top