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
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