<div>
You cannot load Excel File directly into MySQL, you need to convert it to csv first, see here for an example:<br />
<a href="http://lists.mysql.com/mysql/168567" rel="ugc">http://lists.mysql.com/mysql/168567</a><br />
<br />
To automate it, you need to automate the SaveAs function, which should not be too difficult to implement by using the Macro Recorder :-)<br />
Note that you can run a Macro from M$Office from command line, if you need help to locate it, drop a line here.<br />
<br />
There is no &quot;better&quot; 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...<br />
<br />
CHeers
</div>


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 [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

<div>
One thing that may also work would be to import the file into Access then take it from Access into Crystal. &nbsp;I have used this option several times and it has worked great for me. &nbsp;<br />
Good Luck!<br />
Ryan
</div>


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

<div>
<div class="content wysiwyg-content">
Hi!<br />
<br />
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?<br />
<br />
Thx in advance!
</div>
</div>


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!

Importing Excel spreadsheet into MySQL BBDD

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.