Import Filled out Order Form (.txt) into an excel database.

[robbradal]

I have several filled out order forms in .txt format. I'd like data from the
forms to be compiled and arranged in a database. When I import that data it
simply imports the data in the layout of the order form when I want it to
input the data accross the row.

So I have order form, and database, need to figure a way to automate the
process of typing and pasting info from the orderform to the database.

 

[Gord Dibben]

Show us some sample data.

How it is formatted when it comes in and how you want it to be formatted.

e.g. in one column 5 rows

1
2
3
4
5

You want it to be 1 2 3 4 5 in one row across 5 columns.


Gord Dibben MS Excel MVP

 

[robbradal]

I can't give you an example. Its too complicated to describe. What I can tell
you is that the order forms all import in the same format. And I have cells
in the order form that I would like to move into rows.
-Brad

 

[Gord Dibben]

In that case I will bow out and let someone else take a whack at it.

Gord