SQL import with multiple columns
786797Jun 4 2012 — edited Jun 7 2012Hi,
I know how to import multiple columns from a file using fparsestring and i know how to import values from a single Value column in SQL. But now i need to import multiple values from 3 columns from a sql DB at once.
in example
Col1 Col2 Col3 Col4
Account Prod1 Prod2 Prod3
1000 12 234 56
2000 324 34 90
I guess i cannot use fparsestring here...anyone has an idea how to solve this? of what type of function i can use?
With a file, i can identify the columns Prod1 = DW.Utilities.fParseString(strRecord, 4, 2, ","), but how to do this with a Table?
regards
Ben