1. yes
2. Can't find a good example.

   Thanks.

Thanks worked nice.

$source="c:\fileloading" #location of starting directory
$destination="c:\filecopy"; #location where files will be copied to
$files=@("*dys_ihhist*")

Get-ChildItem -recurse ($source) -include ($files) | Copy-Item -Destination ($destination + ($file.BaseName + "_" + (Get-Date -Format...

Thats maybe the issue I don't want a new directory just copy files from Source that conatain "$files=@("*dys_ihhist*")"

in there file name to DEST

Before:

dys_ihhist.txt  --> found on Source

Copy to Dest

dys_ihhist_072023.txt

Thanks Jeff.. correct on incorporating the solution.  I don't want a NEW folder created just a MMYYYY inserted into filename as it's copied to Dest folder.

Thanks again.

Any help getting this to work?

THanks.

I'm just trying to copy file with new MMYYYY into the folder filecopy

$source="c:\fileloading" #location of starting directory
$destination="c:\filecopy"; #location where files will be copied to
$files=@("*dys_ihhist*")

New-Item -ItemType Directory -Force -Path ($destination); Get-ChildItem -recurse ($source) -include ($files) | Copy-Item -Destination ($destination +...

Is it trying to create a New directory

Copy-Item : Access to the path 'C:\filecopy_072023' is denied.

At line:5 char:112

Thanks.

This code seems to find each TAB, but how can I combine with above script to load both tabs to different Tables in SQL?

param(
   ...

# Variables for Import-Excel
$FolderName         = "c:\fileloading\"
$FileName           = "book1.xlsx"
$FileNameWithFolder =...

sorry hit enter twice connection froze.

Emperor100   -- Many thanks that's exactly what I was looking for... sorry if my description of the problem seemed confusing.

Thanks again.

Emperor100,

Thanks for replies it appears the query you had suggested retrieves multiple custnbr's and avglag. I was hoping that the query returns

a single custnbr(based on Max Shipdate) then based onprevious...

Sorry I was using the wrong name ... Shipdate should be used in all occurrences.

This is the backend table that drives the view.

Thanks.

CREATE TABLE [dbo].[ConHist_PY](
[InvoiceNbr] [nchar](10) NOT...