Thank you Amit.
I use S-S 2000.
I ran your entire set of code, but nothing was written to the ouput table. Is your step for 2005 or 2000?
But on the subject of data types, my biggest pet peeve is the over-use of the nvarchar type here at my office.
Oh my, it is so wasteful. For some reason, when developers bring over a table from Access, the SQL table will always have several nvarchar columns which I then have to "clean-up" by changing each to varchar.
A 10-character value stored in an nvarchar column actually uses/occupies 20 bytes of disk space and memory/RAM.
I have recovered several Gigabytes of disk space by simply changing data types in several tables.
**If anyone knows how to change the DEFAULT data type for Access' Text columns when importing them into a SQL table, I would sure like to know that.**
I know there are times when nvarchar is required but in my environment - almost never.