Hey there Graham, Now, I know this is going to be more of a WAG or a total Shot-in-the-Dark, Butt...
Also, I will admit - I am not familiar with the exact process you're attempting to do. I did try something similar MANY Years ago, admittedly - back in like 2012. Anyway... So, my question is this - did your Process at least create the Database files in SQL - and SOME of the records did make it into the Database? If so, why not push the records into SQL Databases from FoxPro after the SQL databases were already created? Now, I know - it's Not Addressing your original problem. But, I figured I would throw some suggestions out there... -Kurt On Thu, Oct 5, 2023 at 8:44 AM Graham Brown <gbr...@compsys.co.uk> wrote: > Hi all > > > > I am upsizing a Foxpro DBC to SQL 2008 r2. This worked fine with earlier > versions of SQL but gives errors to newer versions of SQL. I am using ODBC > rather than Native client although it doesn't make any difference to the > errors. > > > > For one specific table the upsize says 988 rows failed. Only a few records > show an error in the report (6) and this is connectivity error failed to > convert numeric to float. The destination fields do not show float so not > sure what it is complaining about. > > > > Has anyone seen the same please. > > > > Regards > > Graham > > > > Ps Sent the last one to owner@, sorry Ed. > > > > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/CAAMUSVhX-D__WKgqggLt6vJW=-bza3hyepwqthmf04cpmcu...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
