View Single Post
  #2  
Old December 22nd, 2008, 01:23 PM posted to microsoft.public.access.gettingstarted
Jeff Boyce
external usenet poster
 
Posts: 1,555
Default How to transfer data from Excel sheet to External application( Forms)

This newsgroup supports Microsoft Access, the relational database.

Try re-posting in a newgroup that supports Excel.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

wrote in message
...
Hi

I'm Srinivas.

Is there any macro or a software using which i can transfer the Data
from Excel Sheet (Rows) to External Form software with respect to
Heading Description on Form & Excel Sheet.

Below is the sample of data in excel sheet which i have to load in
external application

all this data are in one row . with mentioned Headings

Date ---- 8-Mar-00
Name ---- Diawe M Gunone
mail ID ----
Agent name --- Christina G King
Address -- 204 Zemdon Ave.

Even the the Data Base Form also have the Fields with Same Heading .
What i want is by using a macro or a software i want to transfer the
data from Excel to form . i.e Date to Date Field in Form, Name to Name
Field in Form etc.

Please kindly help me on the same.