Hmmm. How bout pasting into a dbgrid control?
b
------ 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/ema929fe4c-3989-4a25-8d12-06b75fab9b8d%40pathfinder.
