Search : in
By :

Transfer data from Excel and Access into MySQ

Last answer on Apr 3, 2009 1:10:24 pm BST Trscut, on Oct 8, 2008 10:12:47 am BST 
 Report this message to moderators

Hi all,

I need to transfer data (client name, address etc) from excel and access into a MySQL database.
I don't have a lot of technical background and I would like the operation to be as simple as possible.

Any ideas? Thanks!

Configuration: Windows XP
Firefox 3.0.3

Best answers for « Transfer data from Excel and Access into MySQ » in :
How to convert Excel into PDF? ShowHow to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
Transferring data from one hard drive to another ShowTransferring data from one hard drive to another First of all you should use some tools.. transfering data from one hard drive to another is quite simple. Once you have connected the new hard drive to your pc, check your...
Connecting two computers with a USB cable. ShowConnecting two computers with a USB cable. What to choose? How does it work? What to do? If you have to transfer huge files from one PC to another, using a flash disk or burning a CD-ROM can seem like a waste of time. One wise way...
Download Outlook Transfer Show
Download Quick Word to PDF ShowTo transfer your documents most in possible security, there is not better than format PDF. Then, to convert your documents Word into PDF, adopt the quick program Word to PDF. Quick Word to PDF is a tool which integrates with the interface of...
Download EASEUS Partition Master ShowEaseUs Partition manager Free, is software "par excellence". EaseUs Partition Manager easily and without error will resize your hard disk partition into any size you chose: Main characteristics of EaseUs Partition Free: Material support for...
OOP - Data encapsulation ShowThe concept of encapsulation Encapsulation is a way of organising data and methods into a structure by concealing the the way the object is implemented, i.e. preventing access to data by any means other than those specified. Encapsulation...
Spreadsheets - Data Entry ShowCell Content A cell of a worksheet can contain a value or be empty. The value of a cell has two essential characteristics: a type, which means the intrinsic type of the data. There are generally three types of values: numeric values, for example...
The HTTP protocol ShowIntroduction to the HTTP protocol Since 1990 HTTP protocol (HyperText Transfer Protocol) has been the most widely used protocol on the Internet. Version 0.9 was only intended to transfer data over the Internet (in particular Web pages written in...
Ask your question Reply

4

vijay, on Feb 5, 2009 7:28:12 am GMT
  • +2

I am developing a apllication in php where i need some reports to be generated in excel sheets and pdf for that i have to get data from mysql and add that to excel sheet

   
Reply to vijay

6

 Im-ur-neighbor, on Apr 3, 2009 1:10:24 pm BST

You might want to have a look at some ETL tools available on the net. They do exactly what you describe. But are you ready to spend lots of money on software? If not, and since it seems to be a one-shot project, I'd recommend using open source ETL tools, downloadable for free compared to other licensed tools. You can have a look at Talend Open Studio, it's pretty easy even if you don't have much technical background. You can look at it at: http://www.talend.com/

   
Reply to Im-ur-neighbor
Ask your question Reply
They need your help