I don't need to do anything in Access. I have gazillion xlsx files that I need into SQL server table and thinking of using SSIS. But the foreach loop...

Unfortunately, I can't. The data is pretty crappy. Lot fo double quotes and numeric columns preceeded by =".

When I enter the connection string, I get the folloiwng error:

Exception from HRESULT: 0xC0024108

Thanks, that's what I will have to do.

I am dreading creating the format file.

Thanks, that maybe hte problem. I will try to load all fields as varchar and see what happens.

Thanks Old Hand, all files for the same data set come in the same format. So there would be 6 -7 files - each a different data set. But each...

Yeah, it is the date and time stamp of when the file was created.

Thank you. I was waiting for the day when R and SQL Server play nice.

Thanks, the categories are in a table, but not aranged as from and to values.

Also, number of categories may change from one product to another. Some have 3 and others...

Thanks SQLRNNR for your help.

Thanks Dwain for the solution and suggestions. I am working on understanding and adapting the solution to my data.

One of the things that I have noticed is that when all SPs were working as expected, sqlsrvr.exe would take over 5gb of memory under running processes in task manager....

Sorry about that. I was looking in the wrong places - when it comes to names.

Thanks SSC-Forever, these are about half-a-dozen stored proc that I have created and used for over 8-9 months. They did not begin creating this problem, until recently.

The problem does...

Thanks SSCrazy, but i am not using TRY...Catch.

Tina.