Need Script To Import CSV to Access Table

This topic contains 0 replies, has 1 voice, and was last updated by  Forums Archives 5 years, 8 months ago.

  • Author
    Posts
  • #6384

    by butterss at 2013-03-11 16:49:10

    Greetings to all. There is no forum for Powershell And Access, so I chose to post my request here. I am very new to Powershell. I need an example of a script that will import a CSV file to an Access DB table. I currently manually use the import facility of Access to do this, but I need to automate the process.

    TIA,
    Sam Butters

    by cmille19 at 2013-03-12 04:47:26

    Logparser an old Microsoft scripting utility (pre-Powershell) has a feature to import CSVs into MS Access using either the command-line or COM-based scripting. I've got a presentation and script which demonstrate using LogParser with MS Access here: http://sev17.com/2012/07/22/south-flori ... sentation/

    by butterss at 2013-03-12 16:18:57

    Cmille19, which item should I download/review for your proposed solution?

    Thanks,
    Sam Butters

    by cmille19 at 2013-03-13 07:39:07

    The script and presentation link http://sdrv.ms/NMfCiK

You must be logged in to reply to this topic.