import Sql to Excel
I have excel file that have colm with product barcode.
I wish to check sql server in product Table if the barcode is there so the client that work on excel will know if he have this product or not.
If the bar code is in the table I wish to withe somtinge in the right colome of the barcode.
Is ot possible?
Re: import Sql to Excel
Very hard to understand what you are saying, but yes this should be possible. It’s worth taking the time to explain things accurately in more detail, as you will get more responses.
If MS Office is present on the system you are coding for (ie. this isn’t something on the Jodo servers) then you can use the Office ActiveX libraries to modify your Excel document.