Hi I saw the tutorial to insert records via excel using the API into method. (worked :))I need help doing the same thing using an access database table with lead names. I spoke to the consultants at Method however there was no assistance availabe and their suggestion was to use the forum. Here are the sample leads from the sample provided:
I would appreciate if anybody could help me with some code- either DAO or ADO recordsets to insert the records using the API.
Many thanks
Warren
| IsLeadStatusOnly |
Name |
CompanyName |
Salutation |
FirstName |
MiddleName |
LastName |
Email |
Contact |
Phone |
AltContact |
AltPhone |
Fax |
SalesRep |
BillAddressAddr1 |
BillAddressAddr2 |
BillAddressAddr3 |
BillAddressCity |
BillAddressState |
BillAddressPostalCode |
BillAddressCountry |
ShipAddressAddr1 |
ShipAddressAddr2 |
ShipAddressAddr3 |
ShipAddressCity |
ShipAddressState |
ShipAddressPostalCode |
ShipAddressCountry |
| Yes |
Bob Smith |
|
|
Bob |
|
Smith |
bob@email.com |
|
555-123-4567 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Yes |
Amy Jones |
|
|
Amy |
|
Jones |
amy@jones.com |
|
555-222-3333 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Yes |
Wendy Andrews |
|
Wendy |
|
Andrews |
wendy@andrews.com |
555-333-4444 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|