Hi folks
I have downloaded DB tools and took a quick look at it and it seemed to me
that exporting from excel table can only be done
by creating some new table for that purpose in the db. But what do I want to
do? I`d like to copy the contents of excel file to an existing table into
fields that I will have the chance to set myself. If it isn´t possible right
now or even if it was, I have some feature suggestion to the creator of
Dbtools:
* there should be possibility to tell the program that "I want to the text
from the full first row to be written to the mytable col1 and then starting
from the row number 5 add column A information to mytable col3 and column B
to col4 AND column C to col5" and so on.
* And then could be the following feature as well: "Take some substring from
some excel column X and write it to the db table to mycol and take another
substring from the excel column X and write this to another column in the
database table".
It would be really great to have these features as well, this would make
things much easier. So if possible, I would appreciate it. Or does anyone
know of any other free tools that could handle it?
Thanks
Siim Einfeldt
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
