Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Text import maybe via clipboard


Message #1 by "Michael Mitchell" <michael@m...> on Wed, 26 Feb 2003 17:15:01
I get an e-mail from our web site every day and the data contained inside 
it is data that I end up entering into a form via cut and past item by 
item and I want to automate this.

I have included the pertinent info below inbetween the data start and end 
lines (that I added for inclusion here), there are other e-mail headers 
and footers the the web page adds, but this is what I only need.

Any ideas how to automate this?  I thought there might be a way to just 
copy it all to the clipboard then have some function retreive it from 
there and then do some sort of recordset add new procedure.  But I don't 
know how to deal with the structued text nor do I know how to get it from 
the clipboard (maybe just saving it to a file and having Access read it 
from a file, but that is new to me as well.)
   Thanks.

********DATA START****************
Product Demo AutoRequest 1.0
Name=John Doe
Title=Network Admin
Company=Aaccmee Industries
StreetAddress=12345 Main Ave
StreetAddress2
City=Indpls
State=IN
ZipCode=46203
Country=US
Phone=317-555-1212
Email=johnd@a...
********DATA START****************

  Return to Index