| Urgent help!!! Truncating the Zeros [message #374040] |
Tue, 22 May 2001 09:05  |
Sue
Messages: 49
Registered: May 2000
|
Member |
|
|
Hello,
I am trying to import the data from Xl to oracle .What I usually do is first import the data into Access and than export it to the Oracle.But it does the odd thing by removing the the leading zeros. And since these are the employee Ids.I do not want it to truncate what do I do .I cannot use LPAD sinece emplids are of different datalength and I cannot say which is to be padded and which not to.Any Ideas how to do it.
Note :we donot have SQL LOADER my client did not agree for us to have SQL LOADER.
Thanks
SUe
|
|
|
|
| Re: Urgent help!!! Truncating the Zeros [message #374047 is a reply to message #374040] |
Tue, 22 May 2001 10:25  |
Brent Stayer
Messages: 6
Registered: October 2000
|
Junior Member |
|
|
|
I had this problem also......After importing the data into Access, delete all of the records. Change the field types in the empty table in Acess. Import the data again, but import it into the table that you just changed the field types. This has worked for me in the past.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
