Using XML files in a Macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Okidoki - 11 Oct 2007 09:46 GMT

I'm looking for a solution to import XML files (lots of them) to the same MS
Access table.
When I'm doing it now I have so many clicks ...... And have the risk of
forgetting to check the Append data to the same table option.

It would be nice if I can define a button, so I have to click only once to
import the data, let say from a subdirectory to the same table.

Reply to this Message

HiTechCoach - 12 Oct 2007 18:13 GMT

Not sure if a macro will do it , but you should be able to do it with VBA
code.

>I'm looking for a solution to import XML files (lots of them) to the same MS
>Access table.
[quoted text clipped - 3 lines]
>It would be nice if I can define a button, so I have to click only once to
>import the data, let say from a subdirectory to the same table.

Signature

Boyd
Hi Tech Coach
http://www.hitechcoach.com

Reply to this Message

Plaspohl - 16 Oct 2007 14:38 GMT

Schön, dass es soviel News-Gruppen und sonstiges in Hülle und Fülle gibt. Da
weiß man ja garnicht was man alles abbonieren soll. Und das Schönste ist:
Ich kann den ganzen Mist nicht lesen, weil ich ungebildet bin und nicht
englisch spreche.
Hetrzliache Grüße
W. Plaspohl

> I'm looking for a solution to import XML files (lots of them) to the same
> MS
[quoted text clipped - 4 lines]
> It would be nice if I can define a button, so I have to click only once to
> import the data, let say from a subdirectory to the same table.

Reply to this Message

saima - 22 Oct 2007 15:11 GMT

fghhfghfh

> I'm looking for a solution to import XML files (lots of them) to the same MS
> Access table.
[quoted text clipped - 3 lines]
> It would be nice if I can define a button, so I have to click only once to
> import the data, let say from a subdirectory to the same table.

Reply to this Message