Importing Data to sql 2000

[guaro001]

hi gurus

I have information on an access2007 table, the table has been formatted the right way,text,numeric and more text, now here is my liitle problem, when I use the DTS to import the data in sql even thu im using txt as a data type it takes the value as a interger for example 001 I would like to bring to sql that exactly 001 but what comes in is 1,0030 is 30 and so forth, I need 001 and 0030 to be that exactly when in sql server

can someone help and thanks a bunch for all your help

 

[simian336]

Are you using the DTS wizard? It lets you pick the input and output field types.

Simi

 

[djj55]

One way is to create the SQL table then import to that table.


Microsoft loves to help you out as they know what you want even if it is not. I quite using DTS wizard for Excel imports as it did not want to import correctly for me.

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

 

[guaro001]

S.

yes I a using the DTS wizard and it changes the value, I am using text maybe I should use char and it will work.

d

The table is created and that is what I am trying to do with DTS import into it keep the format.

thanks guys for battling with me