Transfer data manually onto other database

[Guertas]

Hello,

I am needing to transfer data onto a Mysql database.
I have had some advice and am trying to find a software solution.

So main features are to be able to migrate large amounts of contacts and
data every day. The migration should be done manually.

Thanks a lot!

 

[kc-mass]

Look here:
http://www.kitebird.com/articles/access-migrate.html#TOC_6
and here:
http://www.bullzip.com/products/a2m/info.php

Regards

Kevin

 

[Jerry Whittle]

Can you link Access to the MySQL tables? Then a simple append query could work.

Can MySQL link to the Access tabls? The same thing in reverse.

Can MySQL accept things like CSV or Excel files for importing. You could
export from Access then import to MySQL.

 

[John W. Vinson]

Hello,

I am needing to transfer data onto a Mysql database.

From... where? Access? Outlook? Someplace else?

I have had some advice and am trying to find a software solution.

So main features are to be able to migrate large amounts of contacts and
data every day. The migration should be done manually.

Thanks a lot!

Depending on where you're transferring from, Access may indeed be a solution.
You can use File... Get External Data... Link to link to one or more MySQL
tables using ODBC, and (depending on the source) you can link to the source
data; you can then run an Append query to copy data from the source into
MySQL, just using Access as a conduit.

Post back with more details if you need help.

 

[Brikdom]

A few solutions exist to migrate contacts and data you can look at. It
depends on the type of software you want to use.
You can look into software such as Informatica or Talend Open Studio, an
open source program.
You could work with proprietary software that can be expensive compared to
solutions such as open source.