Help with importing text forms to excel

jmcmullen

New Member
Joined
Mar 14, 2009
Messages
4
I receive documents from an online form They come in the form of document not database and I would like to bring data into a excel database. Here is where the online form is located that people fill out:
http://www.westierescue.com/adoptapp.asp This is the form I receive in an outlook emal.
A new adoption application has been submitted through the Westie Rescue USA website. Please contact the sender as soon as possible. Thank you! Applicant ID:
Name: Ellen Ehrenkranz
Age:
Address
2006 NW Third Avenue
Delray Beach, FL, 33444
Home Phone: 561-330-2280
Work Phone: (xxx) xxx-xxxx
Cell Phone: (xxx) xxx-xxxx
Email: guilfordmgmtconsultants@gmail.com
Occupation:
Co-Applicant
Name:
Age:
Occupation:
Relation:
Desired Westie
Desired Gender: Prefer Female
Desired Age: Prefer 1-3 yrs
Willing to housetrain? Y
Reasons for adopting a Westie
- Companion for human
Home
Own my home and live there for 15 months
Home type: House
Willing to provide statement from landlord or copy of lease:
Fenced yard: Y
Fence type: wire
Pool or hot tub: Y
Pool fenced off: Y
Number of adults: 1
Number of children: 0
Ages of children:
Allergies to dogs: N
Asthma: N
Primary caretaker: myself
Caretaker has experience: Y
Anyone home in caretaker's absence: N
Can that person exercise the dog: Y
Job requires frequent travel: N
Replacement care during travel: family
Subject to relocation: N
What to do with Westie in case of move: move with dog
How will the dog be exercised: walk
Dog will be alone daily: 3 hours
Dog will be alone evenings:
Where does the dog sleep: inside
Where is dog when alone: Room Confined
Care
Prepared to provide treatment: Y
Commitment for life: Y
Against alteration of pets: N
Current and previous pets
Current Westie: no
Ever owned a terrier: no
Previous Pets
Previous Pet 1
Species: Dog
Breed: English Springer Spanie
Gender: F
Age:
Pet was altered:
Where is the pet now: deceased-owned 13 years
Previous pet died:
Applicant sold or gave away previous pet: no
Dog is current on vaccinations:
If not, reason is:
Current dog housed:
Applicant has trained dog previously:
If yes, type of training:
References
First Reference
Name: Jane Kantrow
Relation: friend
Best time to reach: PM
Phone: 561-330-2280
Second Reference
Name:
Relation:
Best time to reach:
Phone: (xxx) xxx-xxxx
Third Reference
Name:
Relation:
Best time to reach:
Phone: (xxx) xxx-xxxx
Veterinarian
Name:
Hospital:
Phone: (xxx) xxx-xxxx
Address:
City:
State:
Zip Code:
Vet is familiar with previously owned pets:
Vet can be contacted as reference:

Is there anyway I can directly import data into predesigned cells>
I have several hundred.
Any help would be greatly appreciated.
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Hi jmcmullen,

The following code loads the text file into a worksheet.

You will need to edit the Path / Filename details

Code:

Sub LoadTextAdds()
Path = "F:\Temp\Data.txt"
b = 1
FileNumber = FreeFile()
Open Path For Input As #FileNumber
st:
b = b + 1
Input #FileNumber, Item
Cells(b, 1) = Item
If EOF(FileNumber) Then
Close #FileNumber
GoTo endd
End If
GoTo st
endd:
End Sub

Code:

If you sort out loading one file as you want it first, you can move on to loading the rest.


ColinKJ
 
Upvote 0
Sorry for my ignorance but you are going to have to give me more detailed instructions.
I really do appreciate you post. Just not an expert on code and how to use it.
If you have the time can you go through it with me step by step to get the emails into excel worksheet.

I cant tell you how appreciative I am of your help.

Thank you,
Jim
 
Upvote 0
I am not the webmaster. Just the Coordinator for Florida. When the emails come into me from our online forms. The documet you save is all I receive. I can get in touch with webmaster if they need to change code online. So that I receive it as a worksheet.

Thank you,
Jim McMullen
 
Upvote 0
Hi Jim ,

No problem.

A few questions so we can get to where you want to get.

Just going back to your original post, first I assume you want to store that information in an Excel worksheet as a record, and to add additional records as they come in.

If this is correct, do you want to store your records in columns or row. Rows are normal.

When you receive an email with a new txt record, do you save the record in a folder, and do the records have different names.

Just so you know, I'm in Spain, so we have a bit of a time difference, so if I don't respond directly, don't worry I will be back to you..

Colin
 
Upvote 0
Colin,
Wow, Spain how is the weather there. Sorry for the delay I had to get some sleep. I am in Florida. Its like 85 here yesterday.
You are correct I want to keep the records in a worksheet in excel and keep additional records. I have several hundred. Rows would be fine with headers at top. Yes I save the records in folders. Each email comes in in the name of the person filling it out. The subjects are all the same. Adoption application or Volunteer application.
I just took over the Westie Rescue in Florida and I also have 17 pounds of the same type records that are printed out in forms from previous Coordinators. I figure I will use a high speed scanner and try to get those into the computer that way. I do have tons of volunteers but I hate to send all that data around for them to enter. Might take a chance of loosing it. One of the local colleges like Embry Riddle Aeronautical University should have a high speed scanner and I know some people there that might be able to get that done.
Once again I can tell you how much I appreciate your help. What is the lag time? 8 hours or so?
 
Upvote 0
Hi Jim ,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
<o:p></o:p>
I've looked at the data you posted in your original thread, and I've had a look at the Website.<o:p></o:p>
<o:p></o:p>
Two things, I've put together an initial format, so if you could send me a private message with an email address, I'll send it to you for comment. Also, having looked at the website, could I ask if it’s possible for someone to complete a dummy application and respond to all the questions, where there are option buttons, select one, where there are check boxes, check them all.<o:p></o:p>
<o:p> </o:p>
In the section Your Pet Experience, complete two previous pets.<o:p></o:p>
<o:p> </o:p>
When you receive the email file could you forward it to me so I can see how it is formatted, which will be important when loading it into the database.<o:p></o:p>
<o:p> </o:p>
Regards<o:p></o:p>
<o:p> </o:p>
ColinKJ<o:p></o:p>
 
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,916
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top