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
 SQL Server Administration (2005)
 Table data into flat file

Author  Topic 

ksr39
Posting Yak Master

193 Posts

Posted - 2011-08-11 : 06:03:38
Hi All,
As im trying to take the data from a table which contains 350000 records to a flat file.as table data is not in use for now and when ever if its required.we need to reload the data from the flat file as per the condition into the database.i know that we can load the data into flat file but i dont know how to get the data back into the database from a flat file.can any one help me in this regards.

Thanks in Advance.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-11 : 07:44:54
you can use SSIS export import wizard or OPENROWSET or BULK INSERT for that

http://msdn.microsoft.com/en-us/library/ms141209.aspx

http://sqlserver2000.databases.aspfaq.com/how-do-i-load-text-or-csv-file-data-into-sql-server.html



------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

jagdonru
Starting Member

3 Posts

Posted - 2011-08-17 : 09:40:37
try bcp utility and truncate/drop the table.
Go to Top of Page
   

- Advertisement -