Member Avatar for srikkanthan
srikkanthan 36 Light Poster

I have an issue like, I need to insert data from an XML file into MS Access table. I am able to do this with ADO as one by one row. But this terribly hits the performance when the number of rows to be inserted exceeds 1000. Kindly help with any idea.

(In SQL Server 2000, we have this OPENXML capabilities - Is there any 3rd party tool, library to do this in MS Access ?)

  • 1 Contributor
  • 0 Replies
  • 60 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.