Copying Data into Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.....
 
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.....

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]
 
The Access-ESP add-in is still undergoing beta testing...;-)

LeAnne
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top