Adobe, Adobe Acrobat, Adobe Acrobat 9 Pro, excel, Excel 2000, Excel 2002, Excel 2003, Excel 2003 functions, Excel 2003 macros, Excel 2007, Excel 2007 functions, Excel 2007 macros, Excel 2007 workbooks, Excel 2010, Excel Database, Excel error messages, Excel Formatting, Excel Forms, Excel formulas, Excel functions, Excel import/export, Excel macros, Excel VBA, Excel workbooks, Excel worksheets, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel formulas, microsoft excel functions, Microsoft Excel import/export, Microsoft Excel macros, Microsoft Office, Microsoft Office 2003, Microsoft Office 2007, Microsoft Office 365, Microsoft PowerPoint, Microsoft Project, Microsoft Word, Microsoft Word 2003, Microsoft Word 2007, Microsoft Word 2010, Microsoft Word features, office 2010, OpenOffice, PDF, PDF attachments, PDF conversion, PDF Files, PowerPoint 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?