Import data from csv or excel file into sql 2005

[SarahBrochu]

I have more than one excel file to import into sql. How would I do that? Can you point me to the right direction. Thanks, Sarah

[rljones39]

Try this: msdn.microsoft.com/en-us/library/ms140052.aspx

or Google using "Excel", "import", "SQLServer"

[SarahBrochu]

Thank you very much for your reply.
It did not answer my question.

My question to you is, first I will upload a csv file data into sql server 2005. I have a second file that need to be also uploaded into the same database table. What would happen to the data first time uploaded. Will the second set of data will go below the first set of data? or what exactly I should do in order to dump additional data into the same table.

This is why I asked what would I do if i had two set of csv files to upload into the same database table.

Thanks,
Sarah

[rmiao]

Check this one: http://www.sqlis.com

[SarahBrochu]

I am a newby. Can you be more specific and tell me which link I am supposed to be looking at? Thanks.