problem with huge databases in access-XML mentioned

[Julie]

I am using the msxml to download some xml data from a site in ms access
2002. It works fine for records under 4000 or 5000. Once I have to import
a huge XML file, the process takes too long and sometimes fails.

So does anybody have a better way of accessing these huge XML files and also
once they are imported, how can I handle these huge tables that are 5000 to
10000 records big. (brings my pc to a halt)

I know there is a way to do it with a sql client or using access as the
front end and reading the records using sql as the backend.

Please help and it would be great to see a few basic examples to get me
started.

Thanks

 

[Arvin Meyer [MVP]]

You might try using Excel if you can stay under 16,000 rows (records). Then
just import the Excel data. Using XML takes significantly longer and
requires more of a computer's resources that plain text or some other
formats. That's because it carries so much more baggage with it. OTOH, if
you have the resources, it can communicate between programs and operating
systems.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[aaron.kempf]

use SQL Server. MDB is for babies.

SQL Server has a TON more functionality for this; and you can insert
from XML to SQL in a dozen different ways.

-Aaron
ADP Nationalist