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.