ok I was able to import one table!!!! awesome!:-D it shows up in the manager studio db and everything!

Now the only thing is how do I import more like it...

ok i will look into using SSIS for this. Thank you for your help. It looks like i will be learning something new today.

I know i havent given much detail. Sorry about that. it is mainly because i have tried a ton of different things. I am VERY new to SQL server. I...

ok thanks.

I tried those different variations and it didnt work. I'll try again and see what it does.