0

Hello to all,

We are currently using Excel and are thinking of changing. Now we would like to use Mysql. Only problem is that all our customer addresses and other information are on Excel.

Can you help us with this?

Thanks for your feedback.

(Of course title is bad... )

Edited by asmikwen: n/a

3
Contributors
2
Replies
3
Views
8 Years
Discussion Span
Last Post by bgkalbente
1

Hi,

MySQL supports CSV file import.

So you can save the excel addresses to .CSV file and import the CSV file into MySQL.

[If need use SQLYog browser (ver 4.0 is free) which is easy one)

Good luck.

0

As I read on your post, you are needing to get customer addresses to your other database. You could try using some software that will help you in managing the transfer.

I can recommend the use of data integration software such as Datastage (it is a licensed program) or Talend Open Studio (Talend is open source). Tell us how it went.

Hello to all,

We are currently using Excel and are thinking of changing. Now we would like to use Mysql. Only problem is that all our customer addresses and other information are on Excel.

Can you help us with this?

Thanks for your feedback.

(Of course title is bad... )

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.