Results 1 to 4 of 4

Thread: Importing Xml to Access

Threaded View

  1. May 19th, 2010, 07:31 AM #1
    manin
    manin is offline

    Thread Starter
    Member
    Join Date
    Feb 2008
    Posts
    57

    Importing Xml to Access

    Hello I want to build a program, that automatically imports lots of xml files to access database. The number of files, probably will be between 100-500.
    I have a couple of questions.
    1. Sould I work with datasets, open database, close etc? If I want to import only one file, I open access, go tο File > Get External Data ....
      Is there a way to do this through vb, underground for number of files?
    2. If I work with dataset, should I close and dispose connection every time a file is loaded, or should I load all files and then close?
    Last edited by manin; May 19th, 2010 at 07:36 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width