http://forums.method.me/cs/search/SearchResults.aspx?o=DateDescending&u=5896Search results by user ID 5896en-USCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/p/6078/22831.aspx#22831Thu, 07 Aug 2014 14:51:10 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:22831w.Greyvenstein<p><span id="mce_0_start" style="overflow:hidden;">Hi</span></p> <p><span id="mce_0_start" style="overflow:hidden;"></span>No need to resply- I managed to resolve the question myself. Thanks</p>http://forums.method.me/cs/forums/p/6078/22819.aspx#22819Wed, 06 Aug 2014 20:49:01 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:22819w.Greyvenstein<p><span id="mce_0_start" style="overflow:hidden;">Hi I saw the tutorial to insert records via excel using the API into method.<span id="mce_1_start" style="overflow:hidden;"></span> <span id="mce_7_start" style="overflow:hidden;">(worked :))</span>I need help doing the same thing using an access<span id="mce_2_start" style="overflow:hidden;"> database</span> table with lead names. I spoke to the consultants at Method however there was no assistance availabe and the<span id="mce_4_start" style="overflow:hidden;">ir</span> suggestion was to use the forum. Here are the sample leads from the&nbsp;<span id="mce_5_start" style="overflow:hidden;">sample provided:</span></span></p> <p><span id="mce_0_start" style="overflow:hidden;"><span id="mce_5_start" style="overflow:hidden;"></span></span></p> <p><span id="mce_6_start" style="overflow:hidden;">I would appreciate if anybody could help me with some code- either DAO or ADO recordsets to insert the records using the API.</span></p> <p><span style="overflow:hidden;"><br /></span></p> <p><span style="overflow:hidden;">Many thanks</span></p> <p><span style="overflow:hidden;">Warren</span></p> <table cellpadding="0" cellspacing="0"> <tr> <td>IsLeadStatusOnly</td> <td>Name</td> <td>CompanyName</td> <td>Salutation</td> <td>FirstName</td> <td>MiddleName</td> <td>LastName</td> <td>Email</td> <td>Contact</td> <td>Phone</td> <td>AltContact</td> <td>AltPhone</td> <td>Fax</td> <td>SalesRep</td> <td>BillAddressAddr1</td> <td>BillAddressAddr2</td> <td>BillAddressAddr3</td> <td>BillAddressCity</td> <td>BillAddressState</td> <td>BillAddressPostalCode</td> <td>BillAddressCountry</td> <td>ShipAddressAddr1</td> <td>ShipAddressAddr2</td> <td>ShipAddressAddr3</td> <td>ShipAddressCity</td> <td>ShipAddressState</td> <td>ShipAddressPostalCode</td> <td>ShipAddressCountry</td> </tr> <tr> <td>Yes</td> <td>Bob Smith</td> <td></td> <td></td> <td>Bob</td> <td></td> <td>Smith</td> <td class="xl65"><a href="mailto:bob@email.com">bob@email.com</a></td> <td class="xl65"></td> <td>555-123-4567</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>Yes</td> <td>Amy Jones</td> <td></td> <td></td> <td>Amy</td> <td></td> <td>Jones</td> <td class="xl65"><a href="mailto:amy@jones.com">amy@jones.com</a></td> <td class="xl65"></td> <td>555-222-3333</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>Yes</td> <td colspan="2">Wendy Andrews</td> <td></td> <td>Wendy</td> <td></td> <td>Andrews</td> <td class="xl65" colspan="2"><a href="mailto:wendy@andrews.com">wendy@andrews.com</a></td> <td>555-333-4444</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> </table>