Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 409
  • Last Modified:

Importing Excel spreadsheet into MySQL BBDD

Hi!

i need to insert an excel spreadsheet into mysql BBDD. Is there any kind of script or web app to automatically upload file, and then insert all the stuff into BBDD? Is another way better?

Thx in advance!
0
morsa801tons
Asked:
morsa801tons
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
You cannot load Excel File directly into MySQL, you need to convert it to csv first, see here for an example:
http://lists.mysql.com/mysql/168567

To automate it, you need to automate the SaveAs function, which should not be too difficult to implement by using the Macro Recorder :-)
Note that you can run a Macro from M$Office from command line, if you need help to locate it, drop a line here.

There is no "better" way, unless you start writing a full-blown macro or other language, reading the excel sheet data, connect to the MySQL database and update the data as needed...

CHeers
0
 
w003rpbCommented:
One thing that may also work would be to import the file into Access then take it from Access into Crystal.  I have used this option several times and it has worked great for me.  
Good Luck!
Ryan
0
 
Bruce CadizQuality SpecialistCommented:
morsa801tons,

The Excel-to-MySQL product says it can do this for around $30.00. It appears to have a command line options so it could potencially be incorporated in a server side script / cgi program. Hope this helps.
i.e.
mysql.exe --host=... --user=... --password=... -vvf {MySQL database name} < {dump file name}

Product page
http://www.convert-in.com/xls2sql.htm

Free Trial download
http://www.convert-in.com/demos/xls2sqld.exe


Good luck.
Bruce
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now