Import Global Address List using VBA

[Bundi]

Using DoCmd.TransferDatabase to Import Global Address List

Hi,

I have created a table in Access where I have imported our company Global Address List.
I did this using the menu “File > Get External Data > Import” and then just choosing the file type Exchange.
And this has of course worked very nicely, BUT now I would like to accomplish the same thing using VBA as I want to update the table now and then.

I have a few tables that I update from different spreadsheets, and to update these I use the “DoCmd.TransferSpreadsheet” and so on, this works really great and fast too.
So I thought there was a way to maybe use the “DoCmd.TransferDatabase” to import from the G.A.L to the table that I have.
Or is there some other way I should go about to accomplish this?

My thought is that it would be pretty straightforward as it is quite simple doing it using the menu option I wrote about earlier.

I know one can Link the G.A.L, but this is really slow, so that is not an option in my case.

Would be grateful for any suggestion on how to accomplish and import of this kind using VBA.

Thanks in advance, Bundi

 

[SimonB1978]

Hi,

What I do is link the GAL to my DB and run a query against the linked table to create a table that I later work with.

When you want to update it you can either overwrite the table or loop through the linked table and add/modify the entries as needed.

HTH,

Simon B.

 

[Bundi]

Thanks Simon for the suggestion, that could be a way to do it.
However I had my mind set on using the transferdatabase (if there is any way to use it in this way?)

Or a similar way so that I can update all the tables I have in a similar way as soon as I "start up" my db.

Regards, Bundi