How To Include Related Tables In XML File Export

  • Thread starter Thread starter Howard
  • Start date Start date
H

Howard

***Note: 2nd Attempt At Posting This Message, Not Sure
What Happen On 1st Attempt. I Apoligize If Shows Up Twice
****

Hi,
I am attempting to export a table in Access 2002 to an XML
file and would like to include in this export file records
from related tables. I have seen examples on how to do
this from the File Export Dialog, in which a check box
should be available (labeled "Include related Tables") to
set this option.... but for some reason this option is not
displayed on my computer. The table I am attemting to
export, has relationships established, and there are
dependent records on other tables. I just installed
Access 2002 on my computer and this the first time I have
attempted to do this. During the installation process, I
chose all options available, so I am assuming all
necessary export/import feature should be available.
When exporting to XML, the Export Dialog, on the Data tab,
I can see the "Export Data" Checkbox,"Live/Static Data"
options, "Export Location" Texbox, and "Encoding" Combo..
but not "Include related tables" Checkbox. I checked
Access Help and it says I should be able to do this.
Does anyone know how to turn this feature on?

Any help will be greatly appreciated!

Thanks,
Howard
 
Hi Howard,

I'm not certain of this but I believe that the Help topic you mention is
misleading. My Access 2002 installation doesn't offer anything about
related tables. This article
http://office.microsoft.com/assistance/2002/articles/acExportToXmlFromAccess.aspx
(a) mentions "changes to the procedures outlined in the Access 2002 Help
topics made just prior to the release of the product" and (b) does not
mention any "Include related tables" feature.

IIRC Access 2003 is likely to address this. Meanwhile, the simplest
workrounds would seem to be

-export the tables separately and reconstruct the relationships at the
other end

-pull all the fields into a single query and export the result; then
re-normalise into separate tables at the other end if necessary.



***Note: 2nd Attempt At Posting This Message, Not Sure
What Happen On 1st Attempt. I Apoligize If Shows Up Twice
****

Hi,
I am attempting to export a table in Access 2002 to an XML
file and would like to include in this export file records
from related tables. I have seen examples on how to do
this from the File Export Dialog, in which a check box
should be available (labeled "Include related Tables") to
set this option.... but for some reason this option is not
displayed on my computer. The table I am attemting to
export, has relationships established, and there are
dependent records on other tables. I just installed
Access 2002 on my computer and this the first time I have
attempted to do this. During the installation process, I
chose all options available, so I am assuming all
necessary export/import feature should be available.
When exporting to XML, the Export Dialog, on the Data tab,
I can see the "Export Data" Checkbox,"Live/Static Data"
options, "Export Location" Texbox, and "Encoding" Combo..
but not "Include related tables" Checkbox. I checked
Access Help and it says I should be able to do this.
Does anyone know how to turn this feature on?

Any help will be greatly appreciated!

Thanks,
Howard
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
John/Joe
Thank You For Responding to my message. What prompted
me to attempt this, was an past article I read in Access
Advisor Magazine (I believe 9/2001) that article showed a
screenshot of the XML export dialog with a checkbox
labeled "Include related tables".... I wonder if the
version used for the article was pre-release copy of
Access 2002 and dropped by Microsoft on the final
release? Also, the resulting XML export file showed in
the article showed the related tables inbedded in output,
which is desired output I am attempting to obtain. I
wrote the author an e-mail, if he responds to my question
I will post a follow up message.

Thanks Again,
Howard


-----Original Message-----
I agree that A2003 may resolve this and your workarounds are good ideas.
--
Joe Fallon
Access MVP



Hi Howard,

I'm not certain of this but I believe that the Help topic you mention is
misleading. My Access 2002 installation doesn't offer anything about
related tables. This article
http://office.microsoft.com/assistance/2002/articles/acEx portToXmlFromAccess.aspx
(a) mentions "changes to the procedures outlined in the Access 2002 Help
topics made just prior to the release of the product" and (b) does not
mention any "Include related tables" feature.

IIRC Access 2003 is likely to address this. Meanwhile, the simplest
workrounds would seem to be

-export the tables separately and reconstruct the relationships at the
other end

-pull all the fields into a single query and export the result; then
re-normalise into separate tables at the other end if necessary.



***Note: 2nd Attempt At Posting This Message, Not Sure
What Happen On 1st Attempt. I Apoligize If Shows Up Twice
****

Hi,
I am attempting to export a table in Access 2002 to an XML
file and would like to include in this export file records
from related tables. I have seen examples on how to do
this from the File Export Dialog, in which a check box
should be available (labeled "Include related Tables") to
set this option.... but for some reason this option is not
displayed on my computer. The table I am attemting to
export, has relationships established, and there are
dependent records on other tables. I just installed
Access 2002 on my computer and this the first time I have
attempted to do this. During the installation process, I
chose all options available, so I am assuming all
necessary export/import feature should be available.
When exporting to XML, the Export Dialog, on the Data tab,
I can see the "Export Data" Checkbox,"Live/Static Data"
options, "Export Location" Texbox, and "Encoding" Combo..
but not "Include related tables" Checkbox. I checked
Access Help and it says I should be able to do this.
Does anyone know how to turn this feature on?

Any help will be greatly appreciated!

Thanks,
Howard
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
Click to expand...


.
Click to expand...
Click to expand...
Click to expand...
 
Not sure about if it was dropped or just doesn't work right.
Either way - it doesn't work in 2002.
--
Joe Fallon
Access MVP



Howard said:
John/Joe
Thank You For Responding to my message. What prompted
me to attempt this, was an past article I read in Access
Advisor Magazine (I believe 9/2001) that article showed a
screenshot of the XML export dialog with a checkbox
labeled "Include related tables".... I wonder if the
version used for the article was pre-release copy of
Access 2002 and dropped by Microsoft on the final
release? Also, the resulting XML export file showed in
the article showed the related tables inbedded in output,
which is desired output I am attempting to obtain. I
wrote the author an e-mail, if he responds to my question
I will post a follow up message.

Thanks Again,
Howard


-----Original Message-----
I agree that A2003 may resolve this and your workarounds are good ideas.
--
Joe Fallon
Access MVP



Hi Howard,

I'm not certain of this but I believe that the Help topic you mention is
misleading. My Access 2002 installation doesn't offer anything about
related tables. This article
http://office.microsoft.com/assistance/2002/articles/acEx portToXmlFromAccess.aspx
(a) mentions "changes to the procedures outlined in the Access 2002 Help
topics made just prior to the release of the product" and (b) does not
mention any "Include related tables" feature.

IIRC Access 2003 is likely to address this. Meanwhile, the simplest
workrounds would seem to be

-export the tables separately and reconstruct the relationships at the
other end

-pull all the fields into a single query and export the result; then
re-normalise into separate tables at the other end if necessary.



***Note: 2nd Attempt At Posting This Message, Not Sure
What Happen On 1st Attempt. I Apoligize If Shows Up Twice
****

Hi,
I am attempting to export a table in Access 2002 to an XML
file and would like to include in this export file records
from related tables. I have seen examples on how to do
this from the File Export Dialog, in which a check box
should be available (labeled "Include related Tables") to
set this option.... but for some reason this option is not
displayed on my computer. The table I am attemting to
export, has relationships established, and there are
dependent records on other tables. I just installed
Access 2002 on my computer and this the first time I have
attempted to do this. During the installation process, I
chose all options available, so I am assuming all
necessary export/import feature should be available.
When exporting to XML, the Export Dialog, on the Data tab,
I can see the "Export Data" Checkbox,"Live/Static Data"
options, "Export Location" Texbox, and "Encoding" Combo..
but not "Include related tables" Checkbox. I checked
Access Help and it says I should be able to do this.
Does anyone know how to turn this feature on?

Any help will be greatly appreciated!

Thanks,
Howard

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
Click to expand...


.
Click to expand...
Click to expand...
Click to expand...
Click to expand...
 
Joe/John,
Just received e-mail from Ken Bluttman, the author of the
article I mentioned earlier. According to Ken, this
option was in the Beta version of Access 2002, but
apperantly dropped on the final release... he also
mentioned that this option is back on the Access 2003 Beta
version. Wonder if it will make the final release??

Howard.

-----Original Message-----
Not sure about if it was dropped or just doesn't work right.
Either way - it doesn't work in 2002.
--
Joe Fallon
Access MVP



Howard said:
John/Joe
Thank You For Responding to my message. What prompted
me to attempt this, was an past article I read in Access
Advisor Magazine (I believe 9/2001) that article showed a
screenshot of the XML export dialog with a checkbox
labeled "Include related tables".... I wonder if the
version used for the article was pre-release copy of
Access 2002 and dropped by Microsoft on the final
release? Also, the resulting XML export file showed in
the article showed the related tables inbedded in output,
which is desired output I am attempting to obtain. I
wrote the author an e-mail, if he responds to my question
I will post a follow up message.

Thanks Again,
Howard


-----Original Message-----
I agree that A2003 may resolve this and your
Click to expand...
workarounds
are good ideas.
--
Joe Fallon
Access MVP



Hi Howard,

I'm not certain of this but I believe that the Help topic you mention is
misleading. My Access 2002 installation doesn't offer anything about
related tables. This article
Click to expand...
http://office.microsoft.com/assistance/2002/articles/acEx
portToXmlFromAccess.aspx
(a) mentions "changes to the procedures outlined in the Access 2002 Help
topics made just prior to the release of the product" and (b) does not
mention any "Include related tables" feature.

IIRC Access 2003 is likely to address this.
Click to expand...
Meanwhile,
the simplest
workrounds would seem to be

-export the tables separately and reconstruct the relationships at the
other end

-pull all the fields into a single query and export the result; then
re-normalise into separate tables at the other end if necessary.
***Note: 2nd Attempt At Posting This Message, Not Sure
What Happen On 1st Attempt. I Apoligize If Shows Up Twice
****

Hi,
I am attempting to export a table in Access 2002 to an XML
file and would like to include in this export file records
from related tables. I have seen examples on how to do
this from the File Export Dialog, in which a check box
should be available (labeled "Include related Tables") to
set this option.... but for some reason this option is not
displayed on my computer. The table I am attemting to
export, has relationships established, and there are
dependent records on other tables. I just installed
Access 2002 on my computer and this the first time I have
attempted to do this. During the installation process, I
chose all options available, so I am assuming all
necessary export/import feature should be available.
When exporting to XML, the Export Dialog, on the
Click to expand...
Data
tab,
I can see the "Export Data" Checkbox,"Live/Static Data"
options, "Export Location" Texbox, and "Encoding" Combo..
but not "Include related tables" Checkbox. I checked
Access Help and it says I should be able to do this.
Does anyone know how to turn this feature on?

Any help will be greatly appreciated!

Thanks,
Howard

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.


.
Click to expand...
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top