- Joined
- Aug 21, 2007
- Messages
- 1
- Reaction score
- 0
From Access I link to SQL Server Tables and Access formats the data to whatever format it sees fit. Normally this doesn't cause problems.
Except in one instance: The problem I have is when I need to link to a table where the numbers are formatted as a decimal in SQL Server. For some reason these fields link as text and I have no ability to change them (unless I do a format command every time I pull a number).
When I link to numbers formatted as float - this seems to work, but the decimal formats do not.
Is anyone aware of any Access fixes in place or know of any reason why this may be happening or how to correctly link the numbers as numbers rather than text?
Except in one instance: The problem I have is when I need to link to a table where the numbers are formatted as a decimal in SQL Server. For some reason these fields link as text and I have no ability to change them (unless I do a format command every time I pull a number).
When I link to numbers formatted as float - this seems to work, but the decimal formats do not.
Is anyone aware of any Access fixes in place or know of any reason why this may be happening or how to correctly link the numbers as numbers rather than text?