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