Wild stab:
(1) Modify your spreadsheet so that Worksheet Index 0 contains the
column data to be copied; with blank Worksheet Index 1 being the Paste
target;
(2) Have your users copy/paste from Sheet Index 0 to Sheet Index 1
(3) Having already created an Import Specification file (.rgw), have a
form button control effect the import from Sheet Index 1
Then, it's only a matter of resetting Worksheet Index 1.
Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
[email protected] | +011 (909) 238-9012 c | +011 (909) 912-8678 f
------ Original Message ------
From: "Doug Hamilton" <[email protected]>
To: "R:Base List" <[email protected]>
Sent: 7/15/2021 12:03:41 PM
Subject: [RBASE-L] - How to load 1 col of text values from Excel into a
table?
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.
--
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/em58be4b67-a6f9-4f08-8119-a6eb1f96686e%40pathfinder.
