I have had issues in the past with Excel-SQL DTS where it will still drop the leading zero, even into a varchar. In those cases I exported to Tab delimited text file first as in interim step. You might want to try that from Access, and then you can open the text file and ensure they are in there. Then use DTS to transfer from the text file to SQL.
Dan
Dave,
When I import the table form access I can not get the zeros to remain in
tact in the zipcode field no matter if I use char or varchar.
Do you know a solution I could look into?
Thanks,
Mike
[
Todays Threads]
[
This Message]
[
Subscription]
[
Fast Unsubscribe]
[
User Settings]
![]()
