XML

[kltino]

I have a database in use that needs to be formatted in XML. Is there any
literature or info available that would show me how to arrange the table to
be exported in the proper layout? Thanks for any info you can give.

 

[Graham R Seach]

If you're talking about formatting a single table as XML, then there's no
need to format the table. You can output its data in XML format by
right-clicking the table and selecting Export from the context menu. Select
XML from the [Save as type] dropdown, give the file a name, and click
Export.

If you're talking about formatting the entire database; tables,
relationships and all, then the only way I can think of is to get yourself a
copy of Visual Studio .NET and do it from there. There may be another
simpler way, but I'm afraid I don't know of it.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Tony Wickernark]

I'd just reccomend using SQL Server and Access Data Projects

you could get any funcitonality you needed out of a freeware SQL Server
engine

If you're talking about formatting a single table as XML, then there's no
need to format the table. You can output its data in XML format by
right-clicking the table and selecting Export from the context menu.
Select XML from the [Save as type] dropdown, give the file a name, and
click Export.

If you're talking about formatting the entire database; tables,
relationships and all, then the only way I can think of is to get yourself
a copy of Visual Studio .NET and do it from there. There may be another
simpler way, but I'm afraid I don't know of it.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

I have a database in use that needs to be formatted in XML. Is there any
literature or info available that would show me how to arrange the table
to
be exported in the proper layout? Thanks for any info you can give.

 

[Graham R Seach]

Aaron - exactly how will switching to an ADP allow the user to export the
entire data model to XML??

You (try to) sell hammers, so naturally everything looks like a nail!

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

I'd just reccomend using SQL Server and Access Data Projects

you could get any funcitonality you needed out of a freeware SQL Server
engine

If you're talking about formatting a single table as XML, then there's no
need to format the table. You can output its data in XML format by
right-clicking the table and selecting Export from the context menu.
Select XML from the [Save as type] dropdown, give the file a name, and
click Export.

If you're talking about formatting the entire database; tables,
relationships and all, then the only way I can think of is to get
yourself a copy of Visual Studio .NET and do it from there. There may be
another simpler way, but I'm afraid I don't know of it.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

I have a database in use that needs to be formatted in XML. Is there any
literature or info available that would show me how to arrange the table
to
be exported in the proper layout? Thanks for any info you can give.

 

[Guest]

FOR XML syntax

Aaron - exactly how will switching to an ADP allow the user to export the
entire data model to XML??

You (try to) sell hammers, so naturally everything looks like a nail!

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

I'd just reccomend using SQL Server and Access Data Projects

you could get any funcitonality you needed out of a freeware SQL Server
engine

If you're talking about formatting a single table as XML, then there's
no need to format the table. You can output its data in XML format by
right-clicking the table and selecting Export from the context menu.
Select XML from the [Save as type] dropdown, give the file a name, and
click Export.

If you're talking about formatting the entire database; tables,
relationships and all, then the only way I can think of is to get
yourself a copy of Visual Studio .NET and do it from there. There may be
another simpler way, but I'm afraid I don't know of it.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia


I have a database in use that needs to be formatted in XML. Is there any
literature or info available that would show me how to arrange the
table to
be exported in the proper layout? Thanks for any info you can give.

 

[Guest]

and who said everyhthing about the entire model

he's talking about a TABLE

Aaron - exactly how will switching to an ADP allow the user to export the
entire data model to XML??

You (try to) sell hammers, so naturally everything looks like a nail!

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

I'd just reccomend using SQL Server and Access Data Projects

you could get any funcitonality you needed out of a freeware SQL Server
engine

If you're talking about formatting a single table as XML, then there's
no need to format the table. You can output its data in XML format by
right-clicking the table and selecting Export from the context menu.
Select XML from the [Save as type] dropdown, give the file a name, and
click Export.

If you're talking about formatting the entire database; tables,
relationships and all, then the only way I can think of is to get
yourself a copy of Visual Studio .NET and do it from there. There may be
another simpler way, but I'm afraid I don't know of it.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia


I have a database in use that needs to be formatted in XML. Is there any
literature or info available that would show me how to arrange the
table to
be exported in the proper layout? Thanks for any info you can give.

 

[Guest]

and I fully agree

except you dipshits are the ones that only have a hammer

I'm the one that can do SQL Server _OR_ Access.

but i'll be damned if I ever use Jet again

Aaron - exactly how will switching to an ADP allow the user to export the
entire data model to XML??

You (try to) sell hammers, so naturally everything looks like a nail!

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

I'd just reccomend using SQL Server and Access Data Projects

you could get any funcitonality you needed out of a freeware SQL Server
engine

If you're talking about formatting a single table as XML, then there's
no need to format the table. You can output its data in XML format by
right-clicking the table and selecting Export from the context menu.
Select XML from the [Save as type] dropdown, give the file a name, and
click Export.

If you're talking about formatting the entire database; tables,
relationships and all, then the only way I can think of is to get
yourself a copy of Visual Studio .NET and do it from there. There may be
another simpler way, but I'm afraid I don't know of it.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia


I have a database in use that needs to be formatted in XML. Is there any
literature or info available that would show me how to arrange the
table to
be exported in the proper layout? Thanks for any info you can give.

 

[Graham R Seach]

<<...who said everyhthing about the entire model>>
Uhm... "I have a database in use that needs to be formatted in XML", in his
first post.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

and who said everyhthing about the entire model

he's talking about a TABLE

Aaron - exactly how will switching to an ADP allow the user to export the
entire data model to XML??

You (try to) sell hammers, so naturally everything looks like a nail!

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

I'd just reccomend using SQL Server and Access Data Projects

you could get any funcitonality you needed out of a freeware SQL Server
engine



If you're talking about formatting a single table as XML, then there's
no need to format the table. You can output its data in XML format by
right-clicking the table and selecting Export from the context menu.
Select XML from the [Save as type] dropdown, give the file a name, and
click Export.

If you're talking about formatting the entire database; tables,
relationships and all, then the only way I can think of is to get
yourself a copy of Visual Studio .NET and do it from there. There may
be another simpler way, but I'm afraid I don't know of it.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia


I have a database in use that needs to be formatted in XML. Is there
any
literature or info available that would show me how to arrange the
table to
be exported in the proper layout? Thanks for any info you can give.

 

[Susie DBA [MSFT]]

arrange the table to
be exported in the proper layout



does that say anything about having multiple tables?



this person has a single-table database; maybe-- but they're asking
how to format a single table as XML

the answer is 'SQL Server' and 'FOR XML' is the syntax

and I fully agree

except you dipshits are the ones that only have a hammer

I'm the one that can do SQL Server _OR_ Access.

but i'll be damned if I ever use Jet again

Aaron - exactly how will switching to an ADP allow the user to export the
entire data model to XML??

You (try to) sell hammers, so naturally everything looks like a nail!

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

I'd just reccomend using SQL Server and Access Data Projects
you could get any funcitonality you needed out of a freeware SQL Server
engine
If you're talking about formatting a single table as XML, then there's
no need to format the table. You can output its data in XML format by
right-clicking the table and selecting Export from the context menu.
Select XML from the [Save as type] dropdown, give the file a name, and
click Export.
If you're talking about formatting the entire database; tables,
relationships and all, then the only way I can think of is to get
yourself a copy of Visual Studio .NET and do it from there. There may be
another simpler way, but I'm afraid I don't know of it.
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
I have a database in use that needs to be formatted in XML. Is there any
literature or info available that would show me how to arrange the
table to
be exported in the proper layout? Thanks for any info you can give.- Hide quoted text -

- Show quoted text -

 

[Tony Toews [MVP]]

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tom Wimpernads]

again

he is talking about a single table and not a whole database

<<...who said everyhthing about the entire model>>
Uhm... "I have a database in use that needs to be formatted in XML", in
his first post.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

and who said everyhthing about the entire model

he's talking about a TABLE

Aaron - exactly how will switching to an ADP allow the user to export
the entire data model to XML??

You (try to) sell hammers, so naturally everything looks like a nail!

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia


I'd just reccomend using SQL Server and Access Data Projects

you could get any funcitonality you needed out of a freeware SQL Server
engine



If you're talking about formatting a single table as XML, then there's
no need to format the table. You can output its data in XML format by
right-clicking the table and selecting Export from the context menu.
Select XML from the [Save as type] dropdown, give the file a name, and
click Export.

If you're talking about formatting the entire database; tables,
relationships and all, then the only way I can think of is to get
yourself a copy of Visual Studio .NET and do it from there. There may
be another simpler way, but I'm afraid I don't know of it.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia


I have a database in use that needs to be formatted in XML. Is there
any
literature or info available that would show me how to arrange the
table to
be exported in the proper layout? Thanks for any info you can give.

 

[Graham R Seach]

Aaron,

So you would have the OP transfer all schema, queries and data to SQL
Server, learn ADO, rebuild the frontend in ADP mode, learn about XML modes,
write and execute SQL statements using FOR XML - all for the sake of
exporting a single table?

God luck with that. ;-7

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

again

he is talking about a single table and not a whole database

<<...who said everyhthing about the entire model>>
Uhm... "I have a database in use that needs to be formatted in XML", in
his first post.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

and who said everyhthing about the entire model

he's talking about a TABLE



Aaron - exactly how will switching to an ADP allow the user to export
the entire data model to XML??

You (try to) sell hammers, so naturally everything looks like a nail!

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia


I'd just reccomend using SQL Server and Access Data Projects

you could get any funcitonality you needed out of a freeware SQL
Server engine



If you're talking about formatting a single table as XML, then
there's no need to format the table. You can output its data in XML
format by right-clicking the table and selecting Export from the
context menu. Select XML from the [Save as type] dropdown, give the
file a name, and click Export.

If you're talking about formatting the entire database; tables,
relationships and all, then the only way I can think of is to get
yourself a copy of Visual Studio .NET and do it from there. There may
be another simpler way, but I'm afraid I don't know of it.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia


I have a database in use that needs to be formatted in XML. Is there
any
literature or info available that would show me how to arrange the
table to
be exported in the proper layout? Thanks for any info you can give.

 

[IRS Intern]

nobody needs to move anything to SQL Server

it should already be in SQL SERVER

I mean for real kids; ADP won the war-- everyone that loved ADP moved
on to bigger and better things.. like Reproting Services and Analysis
Services


just because there are more MDB jerk-offs here doesn't mean that it's
the best solution


this isn't a popularity contest, kid


Every single piece of data in the world should live in SQL Server--
because it's going to be the native format for the next version of
NTFS = WinFS

Aaron,

So you would have the OP transfer all schema, queries and data to SQL
Server, learn ADO, rebuild the frontend in ADP mode, learn about XML modes,
write and execute SQL statements using FOR XML - all for the sake of
exporting a single table?

God luck with that. ;-7

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

again

he is talking about a single table and not a whole database

<<...who said everyhthing about the entire model>>
Uhm... "I have a database in use that needs to be formatted in XML", in
his first post.
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
and who said everyhthing about the entire model
he's talking about a TABLE
Aaron - exactly how will switching to an ADP allow the user to export
the entire data model to XML??
You (try to) sell hammers, so naturally everything looks like a nail!
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
I'd just reccomend using SQL Server and Access Data Projects
you could get any funcitonality you needed out of a freeware SQL
Server engine
If you're talking about formatting a single table as XML, then
there's no need to format the table. You can output its data in XML
format by right-clicking the table and selecting Export from the
context menu. Select XML from the [Save as type] dropdown, give the
file a name, and click Export.
If you're talking about formatting the entire database; tables,
relationships and all, then the only way I can think of is to get
yourself a copy of Visual Studio .NET and do it from there. There may
be another simpler way, but I'm afraid I don't know of it.
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
I have a database in use that needs to be formatted in XML. Is there
any
literature or info available that would show me how to arrange the
table to
be exported in the proper layout? Thanks for any info you can give.- Hide quoted text -

- Show quoted text -