Excel to Access conversion
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 not merely be a matter [...]

Answer Question   |  August 12, 2009  3:20 PM
Data transfer, Excel 2003, Excel to Access Conversion, Microsoft Access, Microsoft Excel

Excel to Access conversion
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?

Answer Question   |  December 10, 2008  4:11 PM
Access 97, Excel 2003, Excel to Access Conversion, Microsoft Access, Microsoft Excel