Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-08 : 09:56:50
|
| Anthony Ozogu writes "I have a phone number and SS# column in MS Access database table. Now this table was converted from a DBF format to MDB format and the datatype for all attributes came in as text. I changed the attribute datatype to date/time for the date fields and created an input mask for the phone number and ss#. But my problem is that after the DTS, the phone number and the SS# does not tranfer the dashes created by the input mask but the date formats are OK. I am using MSSQL server 7. Thank you for your help." |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2002-03-08 : 13:41:33
|
| Thats because DTS thinks it is a number, you could always set the field it is writing to to char before doing the transfer if you want to keep the dashes, or you could leave this to the front end used to view the data, two choices...... |
 |
|
|
|
|
|
Input Mask in MS Access and SQL DTS