View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
lobl lobl is offline
external usenet poster
 
Posts: 3
Default How do I export XLS tables to MySQL?

By MySQL I mean the MySQL database engine. A client wants to export XLS
tables directly into a MySQL database.

"Joel" wrote:

There is no direct means in excel to export to a database. Access has the
capability to import execel data. You can export data from excel to a CSV
file and then import the CSV into a database. You also can write a macro to
perform the export one row at a time.

It is not clear what you mean by MySQL. can you be more specific about what
database you are trying put the data into.

"lobl" wrote:

How do I export XLS tables to MySQL?