With WScript. Shell without success,
Java and ask how to connect to the ACCESS, the use of the following statements would the text into the ACCESS
Insert into table
Select * from [text FMT=Delimited (^); record=Delimited (#); HDR=yes; database=D:/Documents/WorkSpace/oralce2access/]. 1. TXT

CodePudding user response:

Asp call SQLLDR, not easy to implement, can write data in the asp file (or text file), make a plan on the Windows task, check this text files,