Click to See Complete Forum and Search --> : Need easy way to create data tables


mlibkind
10-03-2007, 11:13 AM
I have a bunch of data files. They contain rows and columns of alpha-numeric data. I want to display them in tables. Is there an easy way to insert the data into tables?

To make it easier, I can put the data in a wide variety of formats, e.g. WORD, EXCEL, tab delimited, comma delimited.

I have about 400 sets of data so hand typing is not an alternative.

Cheers.

Marcus

tracknut
10-03-2007, 02:55 PM
I know in FrontPage and Expressions, if you select a rectangle of cells in Excel, then paste it into FP/E in the "design view", it will create a table out of it. That will work (though the HTML will be messy), but is sort of a one-shot thing. If you're talking about real-time updates of your data files into these tables, that's a completely different story...

Dave

mlibkind
10-03-2007, 04:25 PM
Dave,

Using your suggestion I converted my comma delimited data to an Excel file. When I went to save it I saw that the file can be saved as a web page. I saved it as such and then extracted the formated table data from the code. Fast and simple.

Thanks for the suggestion.

Marcus