Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to Create Photo Directory for the Employee with Excel data file

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 12-08-2009
Member
 
Join Date: Dec 2008
Posts: 70
How to Create Photo Directory for the Employee with Excel data file
  

I wanted to create Photo Directory for the Employee with Excel data file, and also let me know how to create the photo directory, the step by step process would be better option for me.

Thanks in Advance

Reply With Quote
  #2  
Old 12-08-2009
Member
 
Join Date: Jan 2006
Posts: 6,878
Re: How to Create Photo Directory for the Employee with Excel data file

To use an Excel spreadsheet with ASP code, you need to make sure that the spreadsheet data is properly formatted. I'd create a directory called "candidate pictures" and drag and drop the Word pictures into there. insert the pictures as floating images over a suitably sized cell. ADO picks up the column name from the first row of the spreadsheet. Therefore, each column needs a unique name.

The heading names in photodir.xls are "Last Name," "First Name," "Employee," "Extension," and "File Name." The data starts in row 2
Reply With Quote
  #3  
Old 12-08-2009
Member
 
Join Date: Jan 2009
Posts: 150
Re: How to Create Photo Directory for the Employee with Excel data file

You may download the softwares for photo directory that allows you insert photos to your directory. You'll need someone to take charge of scheduling the photo shoots and act as a liaison with the photo directories company if you use one. Compare companies and software. Both will create photo directories at no charge. If you would rather oversee all the production and cost is not a concern, purchase software to create a church photo directory, one option is Picture-Directory online.If you know the photos are all going to of be the same dimension (i.e. portraits), then just size all rows in the spreadsheet to the same height, and the column containing the images to the correct width.
Reply With Quote
  #4  
Old 12-08-2009
Member
 
Join Date: Feb 2009
Posts: 117
Re: How to Create Photo Directory for the Employee with Excel data file

you need to instantiate an ADO Connection object, using server.CreateObject("ADODB.Connection"). Next, you need to tell ADO what provider and which driver to use, as well as where to find the database/spreadsheet file. Then insert the pictures as floating images over a suitably sized cell. They aren't actually the contents of the call, but they will still move and stay in the correct row when the whole table is sorted, or if you insert another row.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to Create Photo Directory for the Employee with Excel data file"
Thread Thread Starter Forum Replies Last Post
Converting data input from Word doc and excel file into a pdf file Adi.Das Windows Software 4 21-02-2012 06:14 PM
How to create macros in Excel that scan data from second sheet Chini mao Windows Software 1 07-01-2012 06:34 PM
How to create alphanumeric data chart in Excel Shaina Na Windows Software 2 07-01-2012 06:00 PM
How to create a Word for Mac merge document by using Excel data? Dwarner Windows Software 5 13-03-2010 12:24 AM
Batch file to create directory with a date in Windows 2003 Aadimoolan Window 2000 Help 2 16-11-2007 02:55 AM


All times are GMT +5.5. The time now is 02:18 PM.