Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing Data to sql 2000

Status
Not open for further replies.

guaro001

IS-IT--Management
Nov 11, 2009
28
US
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
 
Are you using the DTS wizard? It lets you pick the input and output field types.

Simi
 
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. [smile] 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!
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top