Read data directly from a textbox and insert into a table

2 Jun 2006 11:19 PM

Bill Nguyen

Below is the content of a textbox after data was captured from a barcode
scanner. Instead of saving it into a text file and process later, I would
like to be able to read the items (delimited by <CR>) and insert into a
table.

Please help show me an efficient way to do it.

Thanks

Bill

------------

txtCapturedData.Text =

42093308
42093308
810617005363
07600626456
30017569
4C098F18
PRD-06444-003
753759030186
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677
11223344556677

3 Jun 2006 7:18 AM

Cor Ligthert [MVP]

Bill,

I think that you have to explain this more, by instance what kind of table?
And than raw without any keys, because than it can probably only in the same
way as you did it with the textbox or more sophisticated.

Cor

Show quoteHide quote

"Bill Nguyen" <billn_nospam_please@jaco.com> schreef in bericht
news:eqFcGsphGHA.3496@TK2MSFTNGP04.phx.gbl...
> Below is the content of a textbox after data was captured from a barcode
> scanner. Instead of saving it into a text file and process later, I would
> like to be able to read the items (delimited by <CR>) and insert into a
> table.
>
> Please help show me an efficient way to do it.
>
> Thanks
>
> Bill
>
> ------------
>
> txtCapturedData.Text =
>
> 42093308
> 42093308
> 810617005363
> 07600626456
> 30017569
> 4C098F18
> PRD-06444-003
> 753759030186
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
> 11223344556677
>
>