Access Table to SQL server Table mapping

W

wnfisba

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
 
J

John Nurick

Hi wnfisba,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked SQL Tables don't report Cascading Updates and Deletes 2
Best way to deploy Access read-only database that is linked to SQL tables 6
linking from access to SQL tables 4
Access 2007 Linked tables with SQL server 2008 not showing data 0
sql server linked table not accurate 7
Possible to sync Access front end to Sql Server 2000 back end usingAccess? 3
Linked Tables and SQL Server permissions 3
How do you use a checkbox with a linked SQL Server 2005 table? 5

Top