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!

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

Change data type

Status
Not open for further replies.
simma

simma

Programmer
Sep 11, 2001
398
US
Hello
How do we change data type when transferring data from access to sql by DTS?
Sayif we have field which is varchar in access and I want it to be numeric in Sql
Thanks
 
Sort by date Sort by votes
During importing data you should be presented with a wizard that enables you to re-map[called transformation] field names and data types.

________________________________________________________________________________
If you do not like change, get out of the IT business...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

coorsman
  • Locked
  • Question
Column Data Type. 2
Replies
9
Views
894
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
1K
Chris Miller
Chris Miller
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
587
Chris Miller
Chris Miller
Andrzejek
  • Locked
  • Question
Data types and sizes
Replies
18
Views
916
gmmastros
gmmastros
Andrzejek
  • Locked
  • Question
Field types question
Replies
9
Views
623
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top