Member Avatar for asmikwen

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 because: n/a
  • 3 Contributors
  • 2 Replies
  • 89 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by bgkalbente
Member Avatar for MeSampath

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.

Member Avatar for bgkalbente

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... )

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.