Export from .xls to .sql / creating sql queries

Question

Okay guys, I've been having this problem for a few weeks now and I'm getting no-where with it. I have OpenOffice and regular Office softwares. Both produce flawed .csv files, or at least phpMyAdmin can't read neither of these. Yes, I've been trying to change server's settings of uploading, etc. I also tried to contact my web hosting service and they claimed that all the .csv files I've produced are flawed.

Anyway, I'm looking for a way to convert .xls table to SQL. Most of the softwares out there cost money that I don't have. Furthermore, I've seen PHP systems that do just that, so I know this is possible.

Have you checked that your CSV and MyPhpAdmin use the same separater (comma, semicolon, tab, ...)? Anyway, if you want to generate INSERTs from Excel, an easy way is to generate the inserts as an additional column and save just this column as text later on. See the second answer to this question. — Fabian
– Fabian, Commented Nov 20, 2013 at 14:57
What do you mean with "regular Office software"? And what exaclty do you mean with "flawed .csv files"? Can you show an example of an supposedly "flawed" file? And what you expect instead? — user330315
– user330315, Commented Nov 20, 2013 at 17:52
@a_horse_with_no_name - regular: Microsoft's. And I've no idea what is flawed. Iv'e been working on fixing the problem for a few days now (inside the .csv files) and it seems as though I getting no-where. I expect to be introduced to some kind of free software/website/method to convert xls sheet to sql. — Eli Rotenberg
– Eli Rotenberg, Commented Nov 21, 2013 at 8:40

Liko28s · Accepted Answer · 2014-02-06 17:08:25Z

0

No need converted to. sql, you can import directly with phpmyadmin or using tools like navicat for mysql in phpmyadmin go to the option to import, find the file, select the file type (csv or csv loaddata), in part below defines the column separator (if you do not know which opens the file with notepad)

if a very large file using navicat.

Flawed is "defective"?. I assume you have problem with excel, maybe you have defined the same column separator for separating thousands or decimals, use openoffice to open the file

answered Feb 6, 2014 at 17:08

Liko28s

1415 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Export from .xls to .sql / creating sql queries

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related