Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2006
    Posts
    2

    Unanswered: Bulk Install in Access?

    I have near 60,000 insert statements. Is there any way of bulk install rather than line at a time?

    Best,

    Thank you

    DC

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    depends on the insert statements.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Nov 2006
    Posts
    2
    Could you help me understand what you mean by "depends on"?

    Best,

    DC

  4. #4
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    could you help me understand what you mean by '60,000 insert statements'?

    do you really have something like:

    INSERT INTO myTable(aField) VALUES(1)
    INSERT INTO myTable(aField) VALUES(2)
    INSERT INTO myTable(aField) VALUES(3)
    ....
    INSERT INTO myTable(aField) VALUES(60000)

    that seems extremely unlikely to be the best route!

    please add some details.
    -where is the data coming from?
    -what does it look like?
    -where is it going to?
    -what should it look like when it gets there?

    izy
    currently using SS 2008R2

Posting Permissions

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