Building new Access DB using XML Transforms

[rirus via AccessMonster.com]

I am building an Access DB which will contain several tables. It is going to
be used to generate XML files which must conform to a specified schema. My
question is this...

Is it possible to build the tables using the schema, maybe as a transform?

I am guessing it is, but I do not have enough knowledge on transforms to
create one from the schema. Are there help files on this in Access or a site
that could give me info on this? Do I need an XML editor to create the
transforms? Does anyone know how this could be done?

Thanks,


Rirus

 

[Steve]

Hello Rirus,

What you want to do is not trivial! If you don't find any tutorials to help
you and if no one responds with sufficient detail to help you, contact me at
(e-mail address removed) and I will help you. I provide help with Access applications
for a modest fee.

Steve

 

[Fred]

I noticed that nobody answered. Here's my take on it.

Please excuse the directness which is an attempt to be helpful.

XML is sort of an all encompassing language and structure for storage of
information, but per se it is just a low level foundation. The real
definition of any storage is what systems you "build" in xml for such. So,
just saying "XML" says little to nothing about the specifics.

Then you essentially said you are going to use "A (Access) " to build "B(XML
Schema) and then asked if there is a way to build "A" FROM "B". Which is
it?

I think that you are going to have to decide/find out and define the
down-to-earth specifics of what you/they are trying to do. The jargon (XML,
Schema, Transform) is harming progress by obscuring the above question.

 

[John... Visio MVP]

Hello Rirus,

What you want to do is not trivial! If you don't find any tutorials to
help you and if no one responds with sufficient detail to help you,
contact me at (e-mail address removed) and I will help you. I provide help with
Access applications for a modest fee.

Steve

and stevie probably does not how to do it, but it he is willing to take
money for it.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

A few gems gleaned from the Word New User newsgroup over the Christmas
holidays to show Stevie's "expertise" in Word.


Dec 17, 2008 7:47 pm

Word 2007 ..........
In older versions of Word you could highlght some text then go to Format -
Change Case and change the case of the hoghloghted text. Is this still
available in Word 2007? Where?
Thanks! Steve


Dec 22, 2008 8:22 pm

I am designing a series of paystubs for a client. I start in landscape and
draw a table then add columns and rows to setup labels and their
corresponding value. This all works fine. After a landscape version is
completed, I next need to design a portrait version. Rather than strating
from scratch, I'd like to be able to cut and paste from the landscape
version and design the portrait version.
Steve


Dec 24, 2008, 1:12 PM

How do you protect the document for filling in forms?
Steve


One of my favourites:
Dec 30, 2008 8:07 PM - a reply to stevie
(The original poster asked how to sort a list and stevie offered to create
the OP an Access database)

Yes, you are right but a database is the correct tool to use not a
spreadsheet.

Not at all. If it's just a simple list then a spreadsheet is perfectly
adequate...




John... Visio MVP

 

[rirus via AccessMonster.com]

Thanks for the heads up. Where I work we do hire consultants at times, in
fact I am working with one right now. They are brought on under contract and
screened very heavily by a consulting agency. Even If I wanted to I could not
hire Stevie.

I have found some great things on-line, including this site. I know that if I
keeping looking I will find the answer to this XML question.

Thanks again.

Rirus

Hello Rirus,

[quoted text clipped - 4 lines]

Steve

and stevie probably does not how to do it, but it he is willing to take
money for it.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

A few gems gleaned from the Word New User newsgroup over the Christmas
holidays to show Stevie's "expertise" in Word.

Dec 17, 2008 7:47 pm

Word 2007 ..........
In older versions of Word you could highlght some text then go to Format -
Change Case and change the case of the hoghloghted text. Is this still
available in Word 2007? Where?
Thanks! Steve

Dec 22, 2008 8:22 pm

I am designing a series of paystubs for a client. I start in landscape and
draw a table then add columns and rows to setup labels and their
corresponding value. This all works fine. After a landscape version is
completed, I next need to design a portrait version. Rather than strating
from scratch, I'd like to be able to cut and paste from the landscape
version and design the portrait version.
Steve

Dec 24, 2008, 1:12 PM

How do you protect the document for filling in forms?
Steve

One of my favourites:
Dec 30, 2008 8:07 PM - a reply to stevie
(The original poster asked how to sort a list and stevie offered to create
the OP an Access database)

Yes, you are right but a database is the correct tool to use not a
spreadsheet.

Not at all. If it's just a simple list then a spreadsheet is perfectly
adequate...

John... Visio MVP

 

[rirus via AccessMonster.com]

Yes, XML is a low level language. We use it very heavily for writing our
documentation, where it really shines. I have also used it in exporting query
results into an XML file as well as importing and linking an XML file into
Access tables.

What I was wondering is if Access could build tables based on a schema. If
there is no automated way of doing this then I will have to build the tables
manually based on the schema hierarchy.

You are probably right, I should have left out the transform phrase and stuck
to the basic question.

Regards,

Rirus

 

[rirus via AccessMonster.com]

I think I found what I need to get the job done. It looks like there will be
some manual labor involved but in the end I should end up with exactly what I
need.

http://www.altova.com/products/mapforce/data_mapping.html

Regards,

Rirus

Yes, XML is a low level language. We use it very heavily for writing our
documentation, where it really shines. I have also used it in exporting query
results into an XML file as well as importing and linking an XML file into
Access tables.

What I was wondering is if Access could build tables based on a schema. If
there is no automated way of doing this then I will have to build the tables
manually based on the schema hierarchy.

You are probably right, I should have left out the transform phrase and stuck
to the basic question.

Regards,

Rirus

I noticed that nobody answered. Here's my take on it.

[quoted text clipped - 12 lines]

down-to-earth specifics of what you/they are trying to do. The jargon (XML,
Schema, Transform) is harming progress by obscuring the above question.