Powershell - Import CSV into MS-Access Table

Welcome Forums General PowerShell Q&A Powershell - Import CSV into MS-Access Table

This topic contains 1 reply, has 2 voices, and was last updated by

 
Senior Moderator
3 weeks, 5 days ago.

  • Author
    Posts
  • #179424

    Participant
    Topics: 3
    Replies: 18
    Points: 56
    Rank: Member

    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.

  • #179433

    Senior Moderator
    Topics: 8
    Replies: 1085
    Points: 3,651
    Helping Hand
    Rank: Community Hero

    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?

You must be logged in to reply to this topic.