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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Triple Import Process from Excel to Access 2
I want to import an Excel 07 File to my Outlook 07 Contact List 4
Export Data from Excel into Access 5
importing Calendar from Yahoo to Outlook 07? 1
Excel 03 to Excel 07 1
Adding user defined fields to mapping for importing cvs or excel 1
30/12/1899 Error when importing Time from Excel to Access 3
Error linking to excel file 3

Back
Top