Posted by Doug on 10/01/84 11:41

Mr. Portas follows my experience.

When you sometimes have 15 columns, perhaps at some point you scrolled
over, typed something, adn deleted it. the fact that you "touched" a
cell means Excel will remember it, and "help" you by "saving it."
I personally believe that if you are resting on a cell, and autosave
kicks off, that can cause the cell to be marked as "used."
Excel has workbooks and sheets. In DTS you can specify which sheet you
want. It does get confusing, but like Mr. Portas said, DTS is not a bad
way to go.

Also, instead of "pushing" data from Excel to SQL every time, move the
data once, then link a brand new excel sheet/workbook to the SQL table
using "Import External Data". Now the data will reside in SQL, and you
can manipulate it in Excel.

[Back to original message]