473,396 Members | 2,030 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

How to import XML file into Access 2002?

Hi All,

Scenario:
I have a A.xml file containing the following format.
<tblA>
<AID>1</AID>
<tblA>

How do I import it into a tblA table in dbA.mdb?

Thanks in advance. =)
Regards,
Sean
Nov 21 '05 #1
2 3115
Use the DataSet XMLRead method.

MyDataSet.XMLRead("Your XML File Path and Name.xml")

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .

Time flies when you don't know what you're doing

"Sean" <ve******@hotmail.com> wrote in message
news:OG**************@TK2MSFTNGP09.phx.gbl...
Hi All,

Scenario:
I have a A.xml file containing the following format.
<tblA>
<AID>1</AID>
<tblA>

How do I import it into a tblA table in dbA.mdb?

Thanks in advance. =)
Regards,
Sean

Nov 21 '05 #2
sorry that should have been

ds.ReadXml("MyXML.xml")
--

OHM ( Terry Burns )
. . . One-Handed-Man . . .
Time flies when you don't know what you're doing

"One Handed Man ( OHM - Terry Burns )" <news.microsoft.com> wrote in message
news:uk**************@TK2MSFTNGP10.phx.gbl...
Use the DataSet XMLRead method.

MyDataSet.XMLRead("Your XML File Path and Name.xml")

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .

Time flies when you don't know what you're doing

"Sean" <ve******@hotmail.com> wrote in message
news:OG**************@TK2MSFTNGP09.phx.gbl...
Hi All,

Scenario:
I have a A.xml file containing the following format.
<tblA>
<AID>1</AID>
<tblA>

How do I import it into a tblA table in dbA.mdb?

Thanks in advance. =)
Regards,
Sean


Nov 21 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: mark | last post by:
In Access 2000 and 2002, I have created an import specification to import the fixed-width recordset below into an existing table. I am having strange problems with the import of the date and time...
1
by: carverk | last post by:
Greetz All, Is there a way to hide Tables from being displated by the Import Wizard? I have already did the Right mouse click | Properties | Hide Option. The tables disappear from the DB Window,...
5
by: Johnny Meredith | last post by:
I have seven huge fixed width text file that I need to import to Access. They contain headers, subtotals, etc. that are not needed. There is also some corrupt data that we know about and can...
1
by: Wayne Aprato | last post by:
I have a client who is running several Access 97 databases that I have written for them. They are about to upgrade to Access 2003. Is the default file format of Access 2003 still Access 2000 the...
3
by: Danny | last post by:
Hello How can I make access import a tab delimited text file that contains a special char u (but with the dots over it like a german spelling). The u shows with the two dots in the text file but...
1
by: Srini | last post by:
Hi, I am trying to import an xml file which has more than 255 fields. Access is unable to import the xml file into tables and gives the error message "Too many fields defined." in ImportErrors...
4
by: pietlinden | last post by:
I almost feel stupid posting this, but maybe someone else understands what's going on here. I am importing a delimited text file, and have saved an import specification so that for the user the...
7
by: phillip.s.powell | last post by:
We're looking at a GUI interface for our MySQL DB and I am interested in MySQL Administrator, however, one of our requirements is to be able to import/export databases. Is this possible or do I...
1
by: bradjensmith | last post by:
I am importing a pipe delimited text file into MS Access 2002. The text file contains | | aka |space| The resulting table when imported converts the space to a null value. Any suggestions on...
2
by: john | last post by:
I have 400 different Excel-spreadsheetfiles, same structure, all with only one record in it, and all residing in the same folder. Every now and then new Excel files are being added. In my Access...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.