Link to home
Start Free TrialLog in
Avatar of Pranav_IT
Pranav_ITFlag for India

asked on

Data Entry Software which Captures data and saves in Excel with an Photograph.

Dear Team ,

Can you guide me with a free software, where I can put my companys users data with customized fields along with the Photograph. Which can be exported to an Excel.
Avatar of Pranav_IT
Pranav_IT
Flag of India image

ASKER

Dear Team,

I want the software to have the customized fields as follows.

1.)ID      
2.)L/M NO      
3.)STATUS      
4.)F NAME      
5.)ADDRESS      
6.)ADDRESS1      
7.)ADDRESS2      
8.) DIST      
9.) PIN      
10.)STATE      
11.) PHONE      
12.)EMAIL
What prevents you from entering the data directly into a spreadsheet?
Dear Sir,

We dont want all the fields but want to customize it later.
We would be organizing an event wherein we would like photogrps of fixed size to be taken exactly at that moment when the user enters his data
Can you tell me the process of data capture as you visualize it, step by step?
Like (1) entering the data, (2) taking the photo, (3) transferring the data. You see, if you don't need all the fields at the time of capturing the data (which is at the time of taking the photo) then you might have (1) a form to capture some data at the time of taking the photo, (2) write only those data to a database table which has room for other data to be added later.
If this is what you have in mind my question is still valid:-
Why not enter the immediate data directly into an Excel table at the time of taking the photo and add extra columns to the table later?
Dear Sir,

I am looking for the Software for an event, basically an pharma event.
Where all the doctors would attend the event, we need to capture all the details of the doctor.
Step 1: Doctor Comes in Types in all this data, then the photo is taken using the Laptops web cam.

Step 2: Now the second step is to export the data into the excel along with the doctors photograph so that we can create a booklet.

Hope this clears your doubt, i need a software which can allow me to enter data as per my customized needs and then take the photograph and then export it to excel . for creating a booklet
Which are the data to be filled in by the doctor at the event?
Helllo Sir,

Following are the fields for which the usr will put up his data.

1.)ID      
2.)L/M NO      
3.)STATUS      
4.)F NAME      
5.)ADDRESS      
6.)ADDRESS1      
7.)ADDRESS2      
8.) DIST      
9.) PIN      
10.)STATE      
11.) PHONE      
12.)EMAIL
OK. I'll get back to you later today - your tomorrow, more probably.
Have a look at the attached workbook. Press the button on the sheet "Capture", enter data in the form, press OK, find the data on the worksheet "Data".
I hope this will meet your requirements.
121112-Capture-Data.xlsm
Hello Sir,

Thanks a lot for the amazing solution how can i capture the photos for the doctors rest all is fine...you are very good..
ASKER CERTIFIED SOLUTION
Avatar of Faustulus
Faustulus
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Dear Sir,

My laptop has a web cam, the pictures would be taken from a web cam.

Thanks for the Awsome solution, i would  post a new Question for the aading the picture to an Excel databse using VBA.

Reagards

pranav
Sir you are just fantastic, awaiting your answer on the Web cam thing.