Article:		Storing XML in Relational Databases
Subject:		Storing XML in Relational Databases
Date:		2004-08-23 23:38:02
From:		query
Response to: Storing XML in Relational Databases
I need to convert Access table into XML format for onward submission to Middleware. Appreciate your urgent help.

Previous Message

Up

Next Message

• Storing XML in Relational Databases
  2004-08-24 19:09:57 Igor Dayen
  
  Here are a couple of options you may consider:
  (a) export from Access into flat file
  with further conversion into XML using
  custom-made parsing solution or
  using a vendor tool
  (you may check for CredibleXML, see
  http://www.crediblexml.com/);
  (b) export from Access into MS SQL Server
  and generate XML out of SQL Server table with
  use of FOR XML syntax.
  Igor Dayen