I am looking for a way to transfer excel files to a database (the customer is called mbox. How to transfer Excel to a database?). At least I want a script for writing INSERT-commands for me but I tried it with PowerShell but went into a big problem: I can not write the proper for every-loop for this task:
< Pre> if ($ Args.count -q0) {"no parameter-error" exit} "if ($ Args.count -gt 1) {" many parameters-error "exit} if (-not (Test-path $ Argos [0] -Neave * .csv) {"Invaild root or not CSV-file" exit} $ spalten = import- csv $ args [0] - "delimiter"; "$ Spalten.GetEnumerat Echo $ ($ _. Value [$ of]) + "` n ";} P> Please help, also know that I do not know what will be the name of a column.
No comments:
Post a Comment