Ok..still trying..to understand..& learn..

STEP 1DECLARE @archivePath VARCHAR(500), @templateFolder VARCHAR(100), @cmd NVARCHAR(4000);
SELECT @archivePath = 'C:\Users\MyName\Desktop\CT\MyFoldertoImport', -- Excel file path comes here
@templateFolder = 'MyFoldertoImport\'; -- Folder...

Hello,

I'm trying to follow you here's where I am at:

Step 1:

DECLARE @archivePath VARCHAR(500), @templateFolder VARCHAR(100), @cmd NVARCHAR(4000);
SELECT @archivePath = 'C:\Users\MyName\Desktop\CT\MyFoldertoImport',...

Hi Mike,

Yes all columns are of same format. I'm a total newb to SSMS, so let alone SSIS. Not sure if i can reference another thread that may...

I looked back, the new back up in path \Microsoft SQL Server\MSSQL14.SQLEXPRESS01\MSSQL\Backup

is a type: file

where as the original back up was a file, type:  BAK file

That worked perfectly. Thank you so much. I was afraid to erase original db, but thanks to you're confident answer I took leap of faith and back up worked. 🙂

Thanks for pointing me in right direction guys  - Appreciate it.

I see the correct way to do it as:

create table ##Test ([Primary KW] varchar...

Thanks for trying to help -- appreciate it.

Your code produced:

VehicleType    Color    Age
Car    blue    1
Car    blue    2
Car    blue    3
Car    red    1
Car    red    2
Car    red    3
Truck    blue    1
Truck    blue    2
Truck    blue    3
Truck    red    1
Truck    red    2
Truck    red    3

but...

Ok I modified to, 
CREATE TABLE #Vehicles (VehicleType VARCHAR(5) PRIMARY KEY);
CREATE TABLE #Colors (Color VARCHAR(4) PRIMARY KEY);
CREATE TABLE #Ages(Age TINYINT PRIMARY KEY);
GO
INSERT INTO #Vehicles...

Thanks when running I got

Incorrect syntax near '.'.

Hey guys. thanks for your help. I went back and re checked and I had overlooked a result. Your help is really appreciated.

Ok let me try, hmm still missing some data. Here's the updated version I have based on your feedback

select *
from

(select [KD]
from [dbo].[Tab1]

Thanks George & Steve for answering both question regarding where clause and extra column. Very very helpful -- appreciate it!

i'm assuming if i have data such as, below,...