Are you sure that you are talking about ODBC-import ??
Quote:
I have tried importing from dbf, xls
The SQLyog ODBC-import lets you connect to the source database directly.
To get data from Excel into MySQL there are more ways – for instance:
*save as CSV
*export from EXCEL into MySQL (you must have the MyODBC-driver installed).
(these are the traditional ones)
However with SQLyog 4.1 the best way is I think (provided that you have Access too):
Open the Excel file in Access and save. It does not matter whether you “link” the data or “import” them. Now you can use SQLyog ODBC-tool with the Access(.mdb)-file.
Could you please explain a little more about what you are doing. Importing what sort of data from where to where??
If it is ODBC-import you want to do I can send you a paper on that if you PM me your mail adress.