Problem Importing XML file to Access

  • Thread starter Thread starter diannem
  • Start date Start date
D

diannem

I have minimal knowledge of Access and am attempting to
import a large XML file.

I optimistically entered File>Get External Data>Import>
and chose to import both Data and Structure. I am not
getting any records -- just the letters "ac".

I know what the structure is and it's very simple -- just
2 columns of fixed length -- I have the exact values
including start and end. Do I need to define the
structure in Access? Can I do so without using SQL or
other programming language? I am using Access 2002 (XP).

Thank you in advance for any suggestions you may have!!
Dianne
 
Try converting your XML file to a text (.txt) file prior
to importing it into Access.
 
Back
Top