Copying Data into Access

M

Mike

Is it possible to copy Data into access directly such as this

Name Mike
Address 3333 heldfer lane
ss# 111-11-1111

The data has the header as well and i want to copy and paste and dump it
into Access and let Access sort it all and spit it back to me the way I would
like. I have 3,000 emails to do this with.....
 
J

John Vinson

Is it possible to copy Data into access directly such as this

Name Mike
Address 3333 heldfer lane
ss# 111-11-1111

The data has the header as well and i want to copy and paste and dump it
into Access and let Access sort it all and spit it back to me the way I would
like. I have 3,000 emails to do this with.....
Click to expand...

How consistant is the data? How many fields? Does each entry have the
same number of fields, or do they vary?

You will at the very least need some VBA code to read and parse the
data into an Access table.

John W. Vinson[MVP]
 
Top