Importing Text, Excel style - bumped
mfstuart at cox.net
mfstuart at cox.net
Wed May 17 11:37:04 EDT 2006
Hi all,
*** Any other takers on this? There must be something out there that simulates this feature. ***
========================================================
I have a columnar formatted text file that I'd like to "import" into a SQL
database, using RunRev on WinXP.
I'd like the RunRev program to have features similar to Excel's Text Import
Wizard:
- open file dialog
- raw display of first 100 or so lines of chosen text file
- allow user to define the column breaks
- based on users column breaks, read text file and put into a table
field for final approval to import into database
- read into SQL table
I've managed to develop the first two steps in the wizard, but I need help
with the third and fourth steps.
Especially the part where the user defines the distinction of column
placements - Excel's "set field widths (column breaks)".
That is, how to handle the placement and movement of the vertical line for
column breaks.
========================================================
TIA,
Mark
More information about the use-livecode
mailing list