PC Review


Reply
Thread Tools Rate Thread

Difference betwen linked table and exorted data

 
 
Michael Lindekugel
Guest
Posts: n/a
 
      15th Jun 2004
we have some software containing contact information. I have loaded the
information into Access to scrub it before loading the data into Outlook
Contacts.

While testing, I exported some contacts out of a Contact folder to see what
fields are available. about 100 or so fields are available.

from Access I created a table link to Personal Folder/Contacts. about 50 or
so fields are available.

from Access I created a table link to Address Book/Outlook Address
Book/Contacts. about 28 or so fields are available.

Questions
1.) how come all three produce a different quantity of fields?
3.) in Contacts I can see the Category field. how come the Exported data is
the only version that contains the field Category?

cheers,
Michael


 
Reply With Quote
 
 
 
 
=?Utf-8?B?U3VlIE1vc2hlciBbTVZQLU91dGxvb2td?=
Guest
Posts: n/a
 
      16th Jun 2004
The linked table method has major limitations, including the inability to
show even all the reasonably important fields. While articles have been
written on how to expand on this method's obvious features, I've never been
able to duplicate the results. See
http://www.outlookcode.com/d/database.htm#linkedtables .

Each different type of table has its own set of linked fields.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx



"Michael Lindekugel" wrote:

> we have some software containing contact information. I have loaded the
> information into Access to scrub it before loading the data into Outlook
> Contacts.
>
> While testing, I exported some contacts out of a Contact folder to see what
> fields are available. about 100 or so fields are available.
>
> from Access I created a table link to Personal Folder/Contacts. about 50 or
> so fields are available.
>
> from Access I created a table link to Address Book/Outlook Address
> Book/Contacts. about 28 or so fields are available.
>
> Questions
> 1.) how come all three produce a different quantity of fields?
> 3.) in Contacts I can see the Category field. how come the Exported data is
> the only version that contains the field Category?
>
> cheers,
> Michael
>
>
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate the difference betwen two columns -two dates Chi Microsoft Excel Misc 3 24th Mar 2010 04:18 PM
Difference betwen Excel Date () Function and System Date Khalil Microsoft Excel Worksheet Functions 2 16th Jun 2009 01:10 PM
auto fill data into one table based on data from a linked table =?Utf-8?B?RnJlaWRh?= Microsoft Access Forms 5 5th Sep 2007 06:29 PM
Difference betwen C++ and C#. sonu Microsoft ASP .NET 2 24th Dec 2006 06:43 PM
difference betwen.................... gujarsachin2001@gmail.com Microsoft Dot NET 1 24th Jul 2006 12:39 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:53 PM.