Importing Text File To Sql 2000

[dpactrum]

Hello,

I'm trying to import a text file with one column on it onto a table with 2 column on it, first column on the table is for my ID. I ignore the first column but it didn't accept the data?

Needs help

[ck9663]

Hello,

I'm trying to import a text file with one column on it onto a table with 2 column on it, first column on the table is for my ID. I ignore the first column but it didn't accept the data?

Needs help

upload it to your table. populate the first column on the table from your text file. use your 2nd column on yuor table as your ID. once populated, table will not care if your ID is on your first column or not

-- ck