Access 2010 Intro on Office Backstage Site

Great video. Very well done. There is so many different kinds of Access users from beginner to advanced. It was real nice to hear someone from the Access team who lives in those caves underground Redmond tell us that many Access users are actually real developers. So, keep up the good work and don't forget us developers! Again, Congrads on this release. Albert D. Kallal (Access MVP)

Edmonton, Alberta Canada

Off-topic: The blog displays with very small letters in Firefox. :-(

I am trying to transfer a worksheet in Excel to Access. I have done that but the problem is one of the columns are address and in some cases the address is a double (ex. 415-417). It shows up in access as Num! How can I fix that? I have tried formatting the cell in excel but that didn't work. I am lost here. Can someone help me?

I am trying to transfer a worksheet in Excel to Access. I have done that but the problem is one of the columns are address and in some cases the address is a double (ex. 415-417). It shows up in access as Num! How can I fix that? I have tried formatting the cell in excel but that didn't work. I am lost here. Can someone help me?

Cindy Did you do a cut + paste? Or was this an actual Access import? I would suggest you try importing the data (as opposed to cut + paste). The import wizard should give you a chance to import the column as text. Also, this blog is not really setup as a help form. Try the above idea. If this suggesiton don't work, then for more extensive help give one of many Access help forums a try. There a great community at

http://www.utteraccess.com. And, you can try the msAnswers forum here: social.answers.microsoft.com/.../addbuz Albert D. Kallal (Access MVP)

Edmonton, Alberta Canada

Nice to meet some of the real people behind the software!