Altova XMLSpy 2024 Enterprise Edition

When an MS Access database (DB) is created from an XML Schema, the XML Schema datatypes are converted to MS Access datatypes as listed in the table below.

 

XML Schema Datatype

MS Access Datatype

xs:ID

GUID

xs:string

If no facets  varchar (255)

 

Size = either length or maxLength

 

If Size <= 255 varchar (n)

 

else memo

xs:normalizedString

Same as xs:string

xs:token

Same as xs:string

xs:Name

Same as xs:string

xs:NCName

Same as xs:string

xs:anyURI

Same as xs:string

xs:QName

Same as xs:string

xs:NOTATION

Same as xs:string

xs:boolean

bit

xs:float

Number (single)

xs:double

Number (double)

xs:decimal

Decimal

xs:duration

Date/Time

xs:dateTime

Date/Time

xs:time

Date/Time

xs:date

Date/Time

xs:gYearMonth

Date/Time

xs:gYear

Date/Time

xs:gMonthDay

Date/Time

xs:gDay

Date/Time

xs:gMonth

Date/Time

xs:hexBinary

If no facets  varbinary (255)

 

Size = either length or maxLength

 

If Size <= 8000 varbinary

 

else image (OLE Object)

xs:base64Binary

Same as xs:hexBinary

xs:integer

Number (Long Integer)

xs:int

Number (Long Integer)

xs:negativeInteger

Number (Long Integer); value constraint

xs:positiveInteger

Number (Long Integer); value constraint

xs:nonNegativeInteger

Number (Long Integer); value constraint

xs:nonPositiveInteger

Number (Long Integer); value constraint

xs:unsignedInt

Number (Long Integer)

xs:short

-- no equivalent --

xs:unsignedShort

-- no equivalent --

xs:long

-- no equivalent --

xs:unsignedLong

-- no equivalent --

xs:byte

Number (Byte)

xs:unsignedByte

Number (Byte)

 

© 2017-2023 Altova GmbH