Powershell import-csv not recognized

0
votes

I'm trying to make a bat file script that appends the information of a csv to another already existing csv file. I want to use the import-csv command, but I keep getting the error that says:

'import-csv' is not recognized as an internal or external command, operable program or batch file.

I was using Powershell 5.1, so I tried downloading and using Powershell Core 6. That isn't working either. Am I missing a library somewhere?

my code:

import-csv "tinyTesterB.csv"

pause
1
powershellcsvbatch-fileimport-csv
You're trying to run a built-in powershell.exe cmdlet inside cmd.exe - Compo

1 Answers

5
votes

Inside of a bat file or in the cmd shell, you need to start PowerShell to gain access to its commands. Add the following to your bat file instead:

For Windows PowerShell:

Powershell.exe -Command "Import-Csv 'tinyTesterB.csv'"

For PowerShell Core:

Pwsh.exe -Command "Import-Csv 'tinyTesterB.csv'"