*gasp!* The pain we see when people try to move data from Excel into MV. Just have a look at this: nospamNebula-RnD.com/blog/tech/2009/03/xchange-intro1.html Screenshots in blog. Beta available soon...
BTW, it wouldn't help with this project but if anyone wants to export Excel sheets to CSV, see the ExcelExport utility on our freeware page here (no for-fee components of any kind required): nospamNebula-RnD.com/freeware/ Tony Gravagno Nebula Research and Development > From: George Gallen > I Didn't really want to do that. I opted for the > &COMO& solution, then used the editor to delete out > all the TOF's, then saved what was left in > &SAVEDLISTS&. At that point I did a GET.LIST, followed > by a SELECT on the file that the ID's were to point > to. This weeded out all of the blank lines that the > editor was not able to remove. > > Moving over to Excel and deleting columns would have > been choice #2 > > From: Ron Hutchings > > If you can move between your PC and the server. Open > > the spreadsheet, delete all the columns you don't > > want, save the one column as a text file, move the > > file back to the server in &SAVEDLISTS& and you have > > created a list. > > > > > From: ggallen > > > I'm trying to save the first field of a .csv file to a > > > select list, Yes, I can write a program, but I also > > > wanted to try to do it on the fly. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
