Import tabular data

I am attempting to import large amounts of data from Excel into Dreamweaver.
The table format is simple - 2 columns, the first column contains only a 5 or 6
digit number, the second column contains text cells. I have copied and pasted
the data into Notepad, a TAB separating the 2 columns and a Return at the end
of each line. I saved it, and then used the Import - Tabular Data function.
Random characters from the cells in the second column are being truncated -
sometimes just the initial character, sometimes 10 or so, sometimes none.

I've tried various scenarios including cutting the file right down to one row,
but the same truncation occurs.

Can anyone offer any suggestions?

try this.

Open the original file, in Excel.
look in the Excel File menu for Export or Save As.

In the Save As dialog box where you pick where to save the file, there is a
File Type pulldown at the bottom.
Save the file as txt, comma separated values.

Now import that into dreamweaver.

It might be that your textfile is polluted with non standard asci
characters. On mac I open such a textfile in BBEdit and I use the
function 'zap gremlins' to clean the file. Usually this solves the problem.
A texteditor in windows might have the same function....


Joost Kolkman

in kmoore (AT) sybase (DOT) com wrote:

I am attempting to import large amounts of data from Excel into Dreamweaver.
The table format is simple - 2 columns, the first column contains only a 5 or 6
digit number, the second column contains text cells. I have copied and pasted
the data into Notepad, a TAB separating the 2 columns and a Return at the end
of each line. I saved it, and then used the Import - Tabular Data function.
Random characters from the cells in the second column are being truncated -
sometimes just the initial character, sometimes 10 or so, sometimes none.

I've tried various scenarios including cutting the file right down to one row,
but the same truncation occurs.

Can anyone offer any suggestions?