Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 183
  • Last Modified:

IMPORTING DATA FROM ACCESS TO OUTLOOK

Access database to thew previous message
CORP.FORM.003.0001.INMT-Table.accdb
0
99Boot99
Asked:
99Boot99
1 Solution
 
apache09Commented:
Not really sure what you are asking here or what you want to acheive
However, if you are looking to import data from Access DB into Outlook
The easiest way is to consider the data you want to export/import

Then go into outlook'
Go to a similar item in OUtlook you would lile to import
ie, if you want to import Access Contacts into Outlook contacts, go to contacts
In outlook use Imprt/Export Option
Choose Export to File
Choose Access DB

This will then create a access db file of contacts

If you open this in access you can see how outlook formats the contacts in access.

The access DB you want to import into outlook will need to conform to this same format

ONce you have done that, your Access DB will be fine to import into outlook without any issues
0
 
99Boot99Author Commented:
It's not as simple as that.  The headers in Access have to match exactly to  those in Outlook.  The problem lies in to fact that an .accdb file  has to be converted to text before  it's imported to a Outlook .pst file.

If  you'll look at the Experts Exchange Knowledge Base  there is confusion on how this can be accomplished efficiently  & quickly.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now