0

I need upload over 10,000 records into a sql table from a lotusscript agent. Is there a way I can bulk load them? Excel file attachment is an option if I can do it that way. But I have to use lotusscript agent.

gh2m
  • 1
  • 2

1 Answers1

2

Refer to the answers to this question: Insert multiple rows WITHOUT repeating the "INSERT INTO ..." part of the statement?

First figure out what the correct syntax for providing values to a multiple record INSERT is in the particular SQL dialect that you are working with, and then write your LotusScript code to read your data values (from Excel, or from whatever the actual source is) and produce insert them into the right places in a string containing your SQL INSERT syntax. Then submit that SQL string to your database server.

Richard Schwartz
  • 14,463
  • 2
  • 23
  • 41