sql=access=datatypes?

What would be the corresponding data types for the following existing Access
data types:

Autonumber = (UniqueIdentifier?)
Number = (int?Numeric?)
Yes/No = (?)

Thanks...I am trying to convert an access table into an sql server table but
this is my first attempt...sql server seems to have much broader data type
range than access.

Rgds
Jason

Found a possible site to answer my own question:
[url]http://www.schemamania.org/jkl/booksonline/SQLBOL70/html/2_005_64.htm[/url]

Appreciate any other advice on conversions...

ps: would you advice using the RS.Addnew method for a sql server database or
should I adjust code to INSERT?

<jason@catamaranco.com> wrote in message
news:ejxcUoZdEHA.320@TK2MSFTNGP10.phx.gbl...

> What would be the corresponding data types for the following existing

Access

> data types:
>
> Autonumber = (UniqueIdentifier?)
> Number = (int?Numeric?)
> Yes/No = (?)
>
> Thanks...I am trying to convert an access table into an sql server table

but

> this is my first attempt...sql server seems to have much broader data type
> range than access.
>
> Rgds
> Jason
>
>

[Aaron [SQL Server MVP]]

You should probably read this article in full:
[url]http://www.aspfaq.com/2214[/url]

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)




<jason@catamaranco.com> wrote in message
news:ejxcUoZdEHA.320@TK2MSFTNGP10.phx.gbl...

> What would be the corresponding data types for the following existing

Access

> data types:
>
> Autonumber = (UniqueIdentifier?)
> Number = (int?Numeric?)
> Yes/No = (?)
>
> Thanks...I am trying to convert an access table into an sql server table

but

> this is my first attempt...sql server seems to have much broader data type
> range than access.
>
> Rgds
> Jason
>
>

Perfect! Thanks!
"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:uDM9jwZdEHA.2376@tk2msftngp13.phx.gbl...

> You should probably read this article in full:
> [url]http://www.aspfaq.com/2214[/url]
>
> --
> [url]http://www.aspfaq.com/[/url]
> (Reverse address to reply.)
>
>
>
>
> <jason@catamaranco.com> wrote in message
> news:ejxcUoZdEHA.320@TK2MSFTNGP10.phx.gbl...

> > What would be the corresponding data types for the following existing

> Access

> > data types:
> >
> > Autonumber = (UniqueIdentifier?)
> > Number = (int?Numeric?)
> > Yes/No = (?)
> >
> > Thanks...I am trying to convert an access table into an sql server table

> but

> > this is my first attempt...sql server seems to have much broader data

type

> > range than access.
> >
> > Rgds
> > Jason
> >
> >

>
>

[Aaron [SQL Server MVP]]

> ps: would you advice using the RS.Addnew method for a sql server database
or

> should I adjust code to INSERT?

Use INSERT.
[url]http://www.aspfaq.com/2191[/url]