Member Avatar for vsmash

General Question, no code:

I have the daunting task of automating the import of mysql, ms sql and ms access into a central location. I've nailed the microsoft crap using ms sql DTS but even with mysql odbc drivers, cant seem to nail that one. The optional is that I can either import to ms sql or import to mysql but not access.

I've done some googling and found no definitive. Does anyone have advice on import/export options with regard to this?

  • 2 Contributors
  • 1 Reply
  • 80 Views
  • 13 Hours Discussion Span
  • Latest Post Latest Post by Ezzaral
Member Avatar for Ezzaral

Have you tried creating linked tables in an Access database to the MySQL data? You might be able to pull it through DTS that way.

MySQL dump files fed into the bulk loader for MS SQL may be another possibility.

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.