IMPT Excel 07 to Acc 07

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

I am mindboggled and frustrated.

I am running into a issue with importing from a Excel documet that has 2
colums formatted for custom "00000000", when i run my code it imports but
drops the custom fomatting off. how ever when i run a muaual import it
imports just fine. Any suggestions? would prefer to stay away from linking.
if need code let me know and i will post.
 
I am not surprised that the import is dropping the leading zeroes, but it is
weird that the manual import works and the code doesn't. You could attach an
update query to the import routine and add the leading zeroes.

=LEFT("00000000"&[FieldName], 8)
 
Back
Top