Access, Access 2007, Access query, Browsers, Desktop management applications, Desktops, Domain management, Enterprise Desktop, excel, Excel 2003, Excel 2007, GPO, Group Policy, HP, IIS, Installation, Internet Explorer, Microsoft, Microsoft Access 2007, Microsoft Excel, Microsoft Office, Microsoft Office 2007, Microsoft Word, Migration, Office 2003, Office 2007, OS, PC/Windows Connectivity, PDF, Printers, Printing, Scripting, Shared folders, SharePoint, Training, Vista, Vista compatibility, Windows, Windows 7, Windows 7 Administration, Windows 7 in 2010, Windows 7 Professional, Windows errors, Windows Vista, Windows XP, Windows XP administration, Windows XP Pro, Windows XP Professional, Windows XP SP3, Word 2007 VIEW ALL TAGS
Accounting came and asked me if a very complicated Excel spreadsheet that they are using for cash receipts could be "moved" into Access. I explained to them the difference between a spreadsheet and a database and that Access could definitely be used to better handle transactions etc. but it would...
When I import data from MS Excel v2003 into MS ACCESS v97, some of the data converts (numbers) converts to scientific form (4268411 converts to 4.26841e+006) even though I specify that the column format is text. How can I stop this from happening?