Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Access converts fields from Integer to Float

Author  Topic 

the_menace
Starting Member

1 Post

Posted - 2009-01-23 : 13:01:32
How do you prevent MS Access from converting Integer type fields to Float when exporting data to SQL Server?

First, I create an .adp project then it imports the table to SQL Server. The problem is, it converts my Integer type fields to Float which I don't want. Is there a setting for this? Thanks.
   

- Advertisement -