excel help

[shermaine]

I need to convert all these indidvual text files into either excel or
access.
What should i do inorder for these text file to allocate to the right
Field name in row once i click a import data from text file?
Any advise or example?


+-------------------------------------------------------------------+
|Filename: 1032593-untitled.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=3979 |
+-------------------------------------------------------------------+

 

[Peo Sjoblom]

Most people with the wits intact don't open files posted to newsgroups,
maybe you can repost the questions with some description on how the text
files look and how you want them to look after they have been imported

--
Regards,

Peo Sjoblom

(No private emails please)

 

[shermaine]

My text file is something like

Text file 1

Name: Any
Gender: Female
Age: 20
Salary: $1000
Job: Sales
Location: Garden Way

Test file 2

Name: Green
Gender: Female
Age: 23
Salary: $1200
Job: Customer
Location: Theme

So when i import these two data one by one.....it will shift to the
right column based on the firled type.

Data No Name Gender Age Salary Job Location
No (1) Any Female 20 $1000 Sales Garden
Way
No (2) Green Female 23 $1200 Customer Theme
it will continue on & on everytime i import a new text file..........
Can this be done by excel or access?
Please help!

 

[David McRitchie]

Hi shermaine,

See Creating a Spreadsheet from Database data (#dbdata)
http://www.mvps.org/dmcritchie/excel/snakecol.htm#dbbase

I thought it was set up with the colons, but all you have to do
is use text to columns, delimited, use ":" as delimiter to get to
the starting format then install and use the NAddrDB macro.

 

[shermaine]

Does this works with equal sign =

 

[David McRitchie]

Hi shermaine,
No, you are not creating a function, you are installing a macro and
invoking the macro. There are links to how to install a macro and use
a macro right from the link that I gave you, but specifically it is
Getting Started with Macros and User Defined Functions
http://www.mvps.org/mcritchie/excel/getstarted.htm