[AccessD] Powershell...

[Stuart McLachlan]

If the ANPK is going up, I'd suspect a problem with your insert rather than with Powershell.
Is it  an SQL statement?

How about posting the code.


On 16 Aug 2018 at 10:08, Darryl Collins wrote:

> Hi Folks,
> 
> I am trying to use powershell to write from a CSV to an Access Table
> when a file is added to a folder.
> 
> I have the powershell 'trigger' part working and I can get powershell
> to write to a text file when triggered.
> 
> I can open and extract that data in the CSV I need (that is the file
> that saved to the said folder which triggers powershell into action).
> 
> But I want to write the single line from the csv file to an access
> table.  I can create the connection in powershell and it opens the
> table. It even seems to attempt to write it into the table.  No data
> is being written but the auto key is creeping up after every attempt,
> which suggests something is going on.
> 
> Is anyone skilled at powershell code, or can point me to a list /
> group that might be able to help.
> 
> If it helps, I can post the code, but that might not be for a few
> hours.
> 
> Cheers
> Darryl.
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>