IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New Re: Well, if Access had a xml file format and browser reader
from office.microsoft.com

Exporting to XML from Access\tHelp
Assistance > Access 2003 > Working with Data > External Data

Show AllShow All
Hide AllHide All
Applies to
Microsoft Office Access 2003
Microsoft Access 2002

In Access 2002 or later, you can output data to Extensible Markup Language (XML) by exporting to an XML document. You can also output schema files to specific the structure of the XML document as well as a style sheet to describe the presentation of your data.

HideExport a table, query, form, or report as XML

1. In the Database window, click the name of the table, query, form, or report that you want to export, and then on the File menu, click Export.
2. In the Save as type box, click XML Documents (*.xml).
3. Click the arrow to the right of the Save in box, and select the drive or folder to export to.
4. In the File name box, enter a name for the file, and then click Export.
5. In the Export XML dialog box, do one or more of the following:
* To export the data to an XML document, select Data (XML).
* To export the schema to an XML file, select Schema of the data.
* To format your table or query data by using an Extensible Style Language file, select Presentation of your data (XSL).

Note The Data check box must be selected for the Presentation of your data (XSL) drop-down box to be available.
6. Click OK to export to the XML document.

ShowSet advanced options for exporting XML files
Play I Some Music w/ Papa Andy
Saturday 8 PM - 11 PM ET
All Night Rewind 11 PM - 5 PM
Reggae, African and Caribbean Music
[link|http://wxxe.org|Tune In]
New Going the other way around.
Not using Office at all to generate the files, simply exporting a generated XML file that Excel understands. There's probably a way to get XML data into an Access Database, but I'd have to generate all the various things to make it a turnkey interface (i.e. we want to have it be automatically understood and then reimportable into the system (saving the file back as an xml document and then uploading it).

Anyhow, it's academic since excel is the Chosen One - much more pervasive for the account execs than is Access.
     Excel frustrations - (ChrisR) - (7)
         Nit - (jbrabeck) - (3)
             Well, if Access had a xml file format and browser reader - (ChrisR) - (2)
                 Re: Well, if Access had a xml file format and browser reader - (andread) - (1)
                     Going the other way around. - (ChrisR)
         You will have to write a function for it. - (folkert) - (1)
             Don't think their XML format supports script riders... - (ChrisR)
         Nevermind, didn't answer the right question -NT - (Steven A S)

I don't know who thought this up, but it certainly wasn't a bird.
68 ms