Martin Reid
mwp.reid at qub.ac.uk
Sun Jun 11 08:40:41 CDT 2006
Given a standard Access databse what would most say would be the data type mapping. I am just looking at what most people would like to see here. Heres is the working list - not sure how this will show up in email! sorry. Access Data Type SQL Server Data Type binary varbinary Boolean bit byte tinyint currency money date datetime double float GUID uniqueidentifier integer int memo nvarchar(max) memo (Access 97) varchar(max) single real text nvarchar text (Access 97) varchar Martin WP Reid Training and Assessment Unit Riddle Hall Belfast tel: 02890 974477