Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Glenn Duncan   on Sep 08 In MS Office Category.

  
Question Answered By: Tarron Thompson   on Sep 08

I don't have Office 2003, but assume what works in 97 will still work ...

If your numbers  in Excel are entered as text  with leading  zeros they will import
to Access as text and keep the leading zeros. If they are numbers formatted to
show leading zeros, I think the easiest thing to do would be to set the format
on your Access database field with zeros.

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on exporting to access Or get search suggestion and latest updates.


Tagged: