What is a good way to copy/paste rows from a column in a spreadsheet
into rows of a temp table?
The spreadsheet has a column of 10 character text values (part numbers),
the number of rows could range from a few to a hundred.
Users are comfortable highlighting the column and doing a Copy/Paste.
I want to avoid users having to export; c/p is easier for them.
I can paste the values into a variable memo and they display as a column
of text values, SFSG (So Far, So Good).
But when I try to parse through them to INSERT into a temp table, the
variable of part numbers is one long string of characters with no
delimiters. :(
I've tried text, note and varchar datatypes and different settings of
tabs & returns but in the interest of time, I seek the wisdom of this
List vs the number of testable permutations.
Or is there a better way than Paste & Parse? Directly into the temp table?
TIA,
Doug
RBGX5E
--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/2a23c700-17ee-aa2c-e30e-7a61694d6859%40wi.rr.com.
