Access datatypes vs. SQL datatypes

[meldrape]

Greetings,

I have a large database I am converting to SQL, retaining the Access database front end. Is there documentation available comparing the datatypes from Access to SQL? I have several number fields that convert to float, for example. I just want to make sure I have my datatypes correct. Any suggestions would be greatly appreciated. Thanks.

 

[tlbroadbent]

Check this link:

http://www.microsoft.com/office/tec...s/acrefComparingAccesstSQLServerDatatypes.htm

Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[meldrape]

Perfect, Terry as always. Thanks!