If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to transfer data from Excel sheet to External application( Forms)
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. |
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|