[flanok]

great done that

Thanks

Mark

[flanok]

peterlaursen wrote on Sep 18 2008, 05:39 PM:

How are you importing? CSV? SQL-dump? Migration Tool?

Hi

I am doing thus through CSV, I tick the replace button and delete all the lines from the spread sheet, but it just replaces the bits that have been changed and leaves everything else.

[flanok]

Thanks, I was not aware of the freindly excel button.

Once I did this it worked, grest stuff

thanks

[flanok]

peterlaursen wrote on Sep 18 2008, 01:25 PM:

I think the problems might this one

http://webyog.com/faq/content/28/73/en/i-h…g-csv-data.html

” And in most of continental Europe (where the comma is used for decimal notation – ie: “4.123,7” instead of English notation “4,123.7”) it is a de facto convention to use semicolon and not comma as field separator! Localized versions of Microsoft Excel and the Microsoft text-ODBC-driver handles it that way for instance! Thus as CSV really becomes a SSV ('Semicolon Separated Value') in most of Europe. But not matter what: SQLyog handles it all.”

Where are you from? What is the language setting of you computer? What language edition is your MS Office?

If the file uses “;” as field seperator you should enter this character as seperator in the SQLyog import dialogue (“fill excel friendly values” option works only directly with English Excel versions.

And of course you should double-check that the table you import to has the correct number and type of columns.

[Author]

Posts