K
Kelvin Beaton
I have a contact database that I need to import data into on a weekly basis.
The data is in an Excel file with client and contact information all in one
record (one row).
I need all the client data to go in the client table, and the contact
information to go in the contact table.
I need to import the "ReasonForContact" into the ContactData table.
Here are the basic fields in the two tables
tbl_ClientData
ClientID
FirstName
LastName
Address
City
State
Zip
tbl_ContactData
ContactLogID
ClientID
ContactDate
ContactTime
ContactNotes
ReasonForContact
Any help would be appreciated!!!
Thanks
Kelvin
The data is in an Excel file with client and contact information all in one
record (one row).
I need all the client data to go in the client table, and the contact
information to go in the contact table.
I need to import the "ReasonForContact" into the ContactData table.
Here are the basic fields in the two tables
tbl_ClientData
ClientID
FirstName
LastName
Address
City
State
Zip
tbl_ContactData
ContactLogID
ClientID
ContactDate
ContactTime
ContactNotes
ReasonForContact
Any help would be appreciated!!!
Thanks
Kelvin