469,275 Members | 1,287 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,275 developers. It's quick & easy.

Importing Text File To Sql 2000

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
Mar 1 '08 #1
1 1087
ck9663
2,878 Expert 2GB
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
Mar 1 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

11 posts views Thread by Grim Reaper | last post: by
8 posts views Thread by harry | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.