Importing a tab delimitated file to Access.

[Gertrude]

I have never used Access before, and am just trying to help a friend out with it.. I started off with data from a .doc file that was all in tables. I converted the tables to text, and formatted them into a tab delimitated plain text file.

This is a exmple of what the raw data I have looks like.. There are 7,555 total lines I am dealing with so manually entering in all this info is not really a option.

SMITH, FRANK
4130 EAST FAKEAVENUE
SOMECITY, NY 12345	10,000.00	FOR FOOD
ABBEY, CRAIG
12 GRAMERCY PARK
4130 EAST FAKEAVENUE	44,000.00	FOR SOMETHING
LASTNAME, DIANE 
12 GRAMERCY PARK
SOMECITY, NY 12345	30,000.00	FOR CANDY
SMITH, SHERRIE 
4130 EAST FAKEAVENUE
SOMECITY, NY 12345	10,000.00	FOR GUM

I am able to import the data into Access, however it is not displaying it like I want it to. What I want is to basically combine the 3 rows of information into one.. For example have the name, address, city, state, zip, amount of money, and what it was for all in one row. When I import it is creating a row for each line(not that there is anything wrong with that technically its just not what I want in this situation.).

This is what I would like each row to look like..

SMITH, FRANK
4130 EAST FAKEAVENUE
SOMECITY, NY 12345	10,000.00	FOR FOOD

ABBEY, CRAIG
12 GRAMERCY PARK
4130 EAST FAKEAVENUE	44,000.00	FOR SOMETHING

LASTNAME, DIANE 
12 GRAMERCY PARK
SOMECITY, NY 12345	30,000.00	FOR CANDY

etc...

And not like this(what it looks like now)...

SMITH, FRANK

4130 EAST FAKEAVENUE

SOMECITY, NY 12345	10,000.00	FOR FOOD

 

[Gertrude]

I figured out a way to do it. When I copy direct from the .doc file, and paste it into notepad the it is approprietly "tab"ed and all the info is on 1 line..

I think that just saved me from messing around with SQL.

 

[odoe]

Huh, that's interesting. I need to remember that. I was going to say go the Excel->Access route, but hey, whatever works quickest.