Welcome › Forums › General PowerShell Q&A › Powershell - Import CSV into MS-Access Table
Good day all,
I need some assistance getting started on this....i have csv files of partially exported data from one database and i want to inject these into my own database on an hourly basis.
How can i, using powershell, import these files into my database in the most efficient way you know of?
ANY assist would be appreciated as i am still green when it comes to inter-program communication.
Never tried anything with MS-Access. But you should be able to do this with Import-CSV cmdlet and with the help of below blog.
Hey, Scripting Guy! Can I Query a Microsoft Access Database with a Windows PowerShell Script?