Click to See Complete Forum and Search --> : Tab vs CSV
I want to populate a MSfelxgrid or other with the tab delimited data file. The CVS file generated by excel works fine but the tab file direct from Quicken only gives the first column, not all 10 columns. How can I open the tab file, or can I use the ASCII output the Quicken also supplies?
Clunietp
Dec 21st, 1999, 11:11 AM
I suppose you could:
1. Open the text file
2. Read in line by line
3. Use the split function to parse the data
4. You can then regroup the data by using the Join function, with a vbTab separator, then use the .AddLine method of the grid control (I think it's addline, or something similar) to get it into your grid
HTH
Tom
JHausmann
Dec 23rd, 1999, 03:50 AM
You could, in VB,
1) open an excel object and import the tab-delimited file, then,
2) save the file as a CSV.
vbforums.com
Copyright Internet.com Inc., All Rights Reserved.