Hello,
I have developed a VB program (Windows) that reads an Excel spreadsheet.
This spreadsheet has a column that has account numbers. I load the
spreadsheet into a datagridview then I traverse the datagridview and for
each row I invoke a stored procedure (in the iSeries) that indicates
whether the account exists in our account table. This seems to work
fine but it is sort of slow. Does anybody have other ideas or
techniques on how to accomplish the same thing?
Thank you,
Antonio Mira
Application Developer - Mid-Ohio Division
Time Warner Cable
1015 Olentangy River Road - 2nd Floor
Columbus, OH 43212
http://www.timewarnercable.com
phone: 614 827 7949
This E-mail and any of its attachments may contain Time Warner
Cable proprietary information, which is privileged, confidential,
or subject to copyright belonging to Time Warner Cable. This E-mail
is intended solely for the use of the individual or entity to which
it is addressed. If you are not the intended recipient of this
E-mail, you are hereby notified that any dissemination,
distribution, copying, or action taken in relation to the contents
of and attachments to this E-mail is strictly prohibited and may be
unlawful. If you have received this E-mail in error, please notify
the sender immediately and permanently delete the original and any
copy of this E-mail and any printout.
midrange.com
