IMPT Excel 07 to Acc 07

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.
 
R

Roger Converse

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)
 
Top