Imported CSV file data into DB 1

[bigz60]

Hello.

I am working with VB2005 and Sql Server 2005, both express versions.

I have a simple table that contains four columns.

Table name is "mytable"
Column names are: "ssn","Last_Name","First_name", and "hire_date"

I would like to do a onetime mass import of all my 600 employees into this table. I have a csv file that contains all of the data that I need, and nothing extra in the csv.

Also, should my csv file have column names, and if so, do they have to match the db column names.

Thanks in advance.

 

[SiriusBlackOp]

Open SQL Enterprise Manager.
Expand and highlight your databse.
Click the "Magic Wand" on the toolbar.
Expand Data Transformation Services (DTS)
Highlight DTS Import Wizard and click ok

Choose the source as a Text File, and brouwse for your file. Then finish the wizard and run it.

That should import your table.

Senior Software Developer

http://www.scoutsft.com

 

[bigz60]

I'll try that. Thanks.

 

[earthandfire]

bigz60, post your question here: forum183 (or here forum1555 - SSIS has replaced DTS) - they will be able to very quickly give you an SQL Server 2005 answer.

SiriusBlackOp, Enterprise Manager has been replaced in 2005 with Management Studio, which is different (and does things differently)

Hope this helps.

 

[bigz60]

Thank you earthandfire. I will do that.