Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Import data from csv or excel file into sql 2005

Author  Topic 

SarahBrochu
Starting Member

13 Posts

Posted - 2010-06-10 : 09:51:00
I know how to import data from a csv into sql server 2005.

I would appreciate if you could guide me with this:

I want to upload or import one set of data (CSV format) into a database table. I can do this.

I have another set of data that needs to go into the same database table. What would happen to the first set of data in the table? what problems would I have? Can you guide me the right direction please?

Thanks,
Sarah

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-06-10 : 10:23:58
If you do that via stepping through the import wizard then have a closer look at all steps (screens).
I know there is an option to say something like "append rows to the existing table".


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -