How to transfer data from Excel sheet to External application( Forms)

[naidusrinivasalu]

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 ---- (e-mail address removed)
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.

 

[Jeff Boyce]

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


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