Share via

Importing data in XML format/files into access

Anonymous
2010-07-01T13:41:43+00:00

Hi! I was wondering if it is possible to import data from xml files automatically in a access database? I know it is possible for comma delimited files.

Thanks in advance for any answers :)

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
2010-07-01T13:56:33+00:00

Yes, with newer versions of Access. For example A2007 has the import and export options on the External Data tab of the ribbon.

Your version of Access can be found in the About box. In A2007 MSFT carefully hid it at Office Button > Access Options > Resources > About.

Programmers (not end-users) can use what's called an XML parser to import XML into any version of Access.

-Tom. Microsoft Access MVP

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest