-
Import data from csv or excel file into sql 2005
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
-
Try this: msdn.microsoft.com/en-us/library/ms140052.aspx
or Google using "Excel", "import", "SQLServer"
-
Import Export Wizard 2005 sql server
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
-
-
I am a newby. Can you be more specific and tell me which link I am supposed to be looking at? Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|