Hi friends. I'm using MS Office 2007 on Windows 7. I have an excel spreadsheet which is created in MS Excel 2007. Last night I was trying to import it to MS Access 2010 and I successfully did. All data were successfully transferred except the telephone numbers. Though they are appearing but in numbers instead of text form. Have I done something wrong here? Please help me. I would really appreciate your any help. Thanks.
You must be formatting the column after importing the file. Try to avoid it once and see what happens. Is that your own spreadsheet? Have you created that? If you have, then make sure the file or table has no restriction. Regards.