471,108 Members | 1,321 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

Import dbf file into SQL Server - numeric fields shrink by 1 digit

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?

Len Rodberg
Feb 4 '08 #1
1 2838
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?

Len Rodberg
----------------------------
Hi

I am not able to answer your query imm.. But i neeed one help from you...

Now i have to import foxpro dbf files to SQLservet ... Can you please help me..

How you have done using stored procedure..?

Thanks in advence
Feb 28 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by muser | last post: by
1 post views Thread by Service Tech | last post: by
3 posts views Thread by Jon Ole Hedne | last post: by
6 posts views Thread by efrenba | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.