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

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.

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

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


On Tue, 6 May 2008 15:12:01 -0700, robbradal
wrote:

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.

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

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" wrote:

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


On Tue, 6 May 2008 15:12:01 -0700, robbradal
wrote:

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.

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

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

Gord

On Tue, 6 May 2008 20:56:00 -0700, robbradal
wrote:

I can't give you an example. Its too complicated to describe.