Access Table to SQL server Table mapping

[Guest]

We are trying to build a staging table in SQL Server based on the contents of
an Access Database Table.

Can anyone provide me a link which might explain the data type
compatiability between Access Tables and SQL Server Tables???

For example, we have a DECIMAL 9(11,2) in SQL Server. What should we define
the column we'll be using to build this column in Access???

Similarly, we have a DECIMAL 5(8,5) column in SQL Server...What should our
column definition in Access be so that we can insert rows to our SQL Server
staged Table from our Access Table???

Andy help would be GREATLY appreciated.

Thanks.

wnfisba

 

[John Nurick]

Hi wnfisba,

Does the Access Help topic "Equivalent ANSI SQL Data Types" have what
you need?