Powershell - Import CSV into MS-Access Table

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

Viewing 1 reply thread
  • 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: 1152
      Points: 4,000
      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?

Viewing 1 reply thread
  • The topic ‘Powershell - Import CSV into MS-Access Table’ is closed to new replies.