var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How can i automate the importing of several .xml files?
File, Get ExternalData, Import, select next .xml file, options, Append
I have a list of 83 .xml files which i'd like to import. I can do it manually one by one, but this this is something i will need to refresh frequently.
I've got as far as :
Dim strfile As String
ChDir ("\Import Folder")
strfile = Dir("*.xml")
Do While Len(strfile) > 0
'I need this bit
strfile = Dir
I just need the bit in the middle.
Having never specifically imported xml files I cannot be sure of the answer, however, with text files I believe the thing you're looking for is
Let me know if that works.
No, these are .xml files. On Importing, Access works out which tables to create and populte. TransferText just dumps text. So i need a way to automate the process i outlined in the OP.
Originally Posted by
Can you upload a sample .xml file so I can have a further play with the problem.
EDIT: If you can create a macro to import a single file - it can be easily changed to loop through a directory/selection of files.
Last edited by gvee; 02-12-07 at
There doesn't seem to be a macro command for importing .xml, although they can be done singly from the menus.
The whole point about .xml, is that Access knows how to read them and create tables from them.
Does anyone have any experience of importing .xml?
A typical example of one of the .xml files added.
Last edited by severin1962; 02-12-07 at
If you could upload a simple sample XML file that'd be useful.
(I have yet to learn about XML but I'm pretty good in access)
I reckon if I could reproduce your import I could have a go at sorting this for you.