WE ARE TRYING TO CREATE AN ACCESS DATABASE USING DATA FROM AN EXCEL SPREADSHEET. THE EXCEL SPREADSHEET CONTAINS BOTH TEXT AND NUMBERS BUT ALL FIELDS ARE FORMATTED TO TEXT. HOWEVER, WHEN THE LINKED TABLE IS CREATED IN ACCESS, IT CHANGES THE DATA TYPE OF THE FIELDS WITH NUMBERS TO A NUMBER DATA...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.