poppy wrote ...

For some reason when i finsih typing out my sample table data and
preview it, it's not tabbed the way I did it. It just ends up being
jumbled, do you have any idea what is wrong?

You should be using a fixed width-font. I like Lucida Console, which I
use for my VBE editor format.

And about the INSERT INTO - would I be doing it from sql or in vba?

You could do it from SQL Server but it would be easier to do on the
Excel side. Either in MS Query (Data, Get External Data, New Database
Query, make connection, get to the SQL window and start typing) or ADO
in VBA code.

Jamie.

--