I found these two knowledge base articles by Microsoft very helpful when I was the first manipulating spreadsheets from MS Access.

http://support.microsoft.com/default.aspx?scid=kb;en-us;246335

http://support.microsoft.com/default.aspx?scid=kb;EN-US;247412