Transfer Data from excel or outlook to Access

[daniels012]

I have address data stored in Excel. Everytime we add a new customer, we add the address to this list. Is there a way to transfer this data to an Access table? And possibly weekly update to the same table.

Or! each of our salesman have these addresses in Outlook. Could I do the same thing? I don't want to transfer duplicates each time though. Is there code or a way to do this easily?

Thank You,
Michael

 

[PHV]

You may have access tables linked to excel spreadsheets, outlook address folder.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[daniels012]

This is not practical. We have salesman with laptops. They meet at the office each week, where they can update the data as needed. Just don't know how.

Michael

 

[PHV]

You may consider the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[daniels012]

What method is that?