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
 General SQL Server Forums
 New to SQL Server Programming
 create a table from a .csv file

Author  Topic 

michael999
Starting Member

9 Posts

Posted - 2011-12-02 : 15:45:46
hi
I have a .csv file with four columns, an id number and three bits of data.
What is the easiest way to create a database table from this data please?
thanks
michael

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-03 : 00:19:31
use ssis export import or BULK INSERT

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

Go to Top of Page

jassi.singh
Posting Yak Master

122 Posts

Posted - 2011-12-03 : 09:36:41
Hi,

Check this link, easy to understand and with examples

http://msdn.microsoft.com/en-us/library/ms188365.aspx
Go to Top of Page
   

- Advertisement -