I have a table with 20 rows. I want to import 10k+ rows from an Excel. Do i have to have every column on the excel to match the table in SQL, not just the ones i want to insert? I'm just confused why i cannot get this to import.
I want to be able to just say insert these items into this table...
I use Microsoft Dynamics GP 10. I need to update all dimensions of all items.
I know SQL and have googled around to see how to do a very large update on 3 columns for 20000+ rows but can't find anything that really looks like the best way possible without locking up my server.
How would I be...
I have a Flexibility Screen trying to load and I'm getting the Microsoft Forms error, "Could not load objects because they are not available on this machine." Is there an OCX or DLL needing to be registered. This only happens on new installs. Macola 9.5
Under OE & RMA and Price Codes when trying to launch Price Code Maintenance, i receive the error Could not load objects because they are not available on this machine. How can I resolve this issue. It does this on any new install on Win7, WinXP, x86, and x64.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.