I will look at these solutions the moment I get too the office thank you so much guys. Just an fyi, 10 records was just an easy number to discuss....

What I am THINKING of doing... just as a matter of reference here. I am thinking of importing the definition xls sheet as a lookup table

THEN Import the data to...

Does not work unless I re-write it... I just happen to need this exact thing right now... Gives me a couple ideas on how to handle the challenge, thank you......

Thank you sir, I will have a look. If I get that working I will surely share.

Ok I just read that there is not a 64 bit version of this ( Microsoft.Jet.OLEDB.4.0 ) and I am on a 64 bit machine.

No really it is greatly appreciated.

I found some things on the link given in this thread by another user. I am having a problem with that code and I...

Yes.

Right now I know how to create a NEW workbook and insert a row, or multiple rows of data.

In this example I need to open an EXISTING workbook that contains...

Lowell,

Thank you for the link. I will be reading this at lunch as well.

Wayne,

Thank you so much for your reply. Ok I am not using the OpenDataSource method... Here is the code I am using to generate a simple spreadsheet now:

USE [eDirect]

GO

SET...

I suppose I see your point to some extent. HOWEVER.

1. I am not a application developer however I do code in SQL. For this reason SQL is my resource...

Right....

I am looking for some recommendations into doing this natively through Excel. Not sure how my job title plays into this however any recommendations on the coding FROM a...

I tried creating your function. It is throwing an error and I can't see why at all:

Msg 102, Level 15, State 1, Procedure fn_CheckForHoliday, Line 76

Incorrect syntax near ')'.

SQL Server...

I would not use a CURSOR here, well anywhere really.... What I would do if you needed to iterate through a logic then I would use a TABLE VARIABLE.

There is...

That's just it.. I am not an SSIS guy.. Never actually used it and I really need to get up to speed on it to be honest.

Your picture, is that...

Yeah you can. I am not good with SSIS to be honest so someone else can jump in here.

I am 2010 64bit.. Version not an issue with regards to this...