great work this.

Got it working for the best part.

the one thing i cant seem to figure out is that excel process stays running in memory.

so if i am looping through worksheet creation...

been trying something similar but i cannot seem to configure the Microsoft.Office.Interop lib to work

Im getting Excel.Application is not defined.

ive installed the Office 2003 Primary Interop Assemblies redistributable package.

is there...

my bad my question should have been whats he best way to increment the second column when inserting data to it.

Ident is no good on the table design as I...

Hi,

No its not homework its work work 🙂

thanks for your replies guys.

I was going wrong by not including distinct.

It seems to be working now but just need to validate it...