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...

Thanks did find answer on there site.

Thanks for all replies!!

Will test out Emperor100 solution.  Just need a way to update the sp's that use this table structure when new month starts.

I don't have access to the code that creates the new table, or I would piggy back that process..

Just trying to avoid any manual interaction with my SP that uses...

Thanks Scott and Michael L John

what do I swap out for DATEDIFF_BIG ..

I saw an example that combined multiple sql queries, and yes this does produce the desired results but I have no idea how to get this into the HTML format...

If I display $HtmlTable1 I can see both pieces, I want to send out via email..... If I then close my Initial

for each after that

$connection.Close()

}

email stuff then after that I...

Okay I have the format correct but still getting 2 emails ..

How do I roll them all up in 1 email ?

If I look at output from:

$table = $DataSet.tables

$table   --...