Importing text file into tables

[Newbie1969]

Hello All,

I need some assistance. I have created a table in my sql database and I'm trying to import data from a text file into that table.

I have tried the DTS (import tool) but it doesn't transfer into my already created table, instead it will create a new table and isn't set up the way I want it(has only one column and rows are divided by colons). Please advise in layman's terms.

Thanks in advance.

 

[Newbie1969]

ok..I found out how to do the importing. Now I'm having a problem with the results. When I manually enter the data, the results are accurate and code in application is working fine, but for some reason when I use DTS(SQL) my code in the application isn't working properly. Please Advise.

Thanks in advance.

 

[mrdenny]

You will need to be way more specific that "my code in the application isn't working properly".

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Newbie1969]

First of all, thank you for responding.

I have a table in my Sql database that has columns for first name, last name, SSN, and password.

When I manually enter the first name, last name, and SSN in the table(I enter all data except for the password) it will automatically extract the last 4 digits of the person's SSN in the database table as their password. (Which it is supposed to do)BUT

When I use the DTS tool, it will not automatically extract the last 4 digits of the SSN as the password in the table. It leaves the password column blank. Please advise.

Thanks in advance