I am using the SQL import wizard to create my table with the data i want to then import into my table needing the updated info.
This is the table i want to update. Some of the items are not in that table yet, will an insert have to be done in order to then do an update?
ITEMNMBR RBI_Kit_Type...
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 have a test database to fool around in for things. So no worry there.
The information in the NEW table is just the item number, length, width, height, so nothing else would match as another column although i guess i could create a column with 1,2,3,4 as the value to separate this into batches...
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...
How would i find the filename? When the VB opens to debug, a Compile Error pops up stating Method or data member not found and highlights the .MacSearch2.Enabled = True
When the VB script opens .MacSearch2.Enabled = True is highlight and under tools, references is greyed out. We have it installed on some machines working fine but its been a while since we have installed it and can't figure this error out.
Any ideas?
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
This price code maintenance screen is 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.
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.