I have a table in MS sql Express that I need to use in queries for my database. I've set up an odbc connection, and I can view the sql express table in Access. However, all of the double fields in the sql table display as number fields in Access, and they are a very odd format. For instance, zero displays as .00000000, and 25.82 displays as 25.82000000. In addition, I need to pull out some of these records and append some data into a table in my database and it fails every time because of "validation errors." I'm not sure if the number to text thing is causing the problem, but I'd very much like to know why it displays as text instead of a number. Has anyone seen this and is there a fix?
"Talking" to sql express
- Thread starter ckiley
- Start date
