For years I have been importing FoxPro dbf files into SQL Server using a SQL procedure. Everything worked fine.
Recently I had to reinstall some of the software. Now, when I import such a file, each numeric field ends up in SQL Server with the numeric fields 1 digit smaller (i.e., a size-7 numeric field becomes size=6). Character fields are unchanged.
Any idea why this is happening and how to correct it?