Source language: Translate to:

Transfering data from MySQL to MS Access...

Questions about NeoBook PlugIns

Moderator: Neosoft Support

Transfering data from MySQL to MS Access...

Postby David de Argentina » Mon Nov 18, 2013 6:37 pm

Hi all

My new project needs to move data located into a remote MySQL Server to a local MS Access database.

Each time program starts, connects to the remote MySQL database, extracts new registers from 2 tables, and put the result into a response webpage.

I think each time program starts, i need update the local MS Access database with 100 to 500 records for each table.

Records contains Varchar, Numeric and DateTime fields.

The question is:

What is the fastest method to import the data into the local MS Access database ?

I use the NeoBookDBPro plugin for this program.

Thanks in advance
David de Argentina
User avatar
David de Argentina
 
Posts: 1553
Joined: Mon Apr 04, 2005 4:13 pm
Location: Buenos Aires, Argentina

Re: Transfering data from MySQL to MS Access...

Postby Neosoft Support » Tue Nov 19, 2013 11:21 am

I would think the easiest and fastest method would be to export from MySQL to CSV, then import into the Access table via DBPro.
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5593
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Re: Transfering data from MySQL to MS Access...

Postby David de Argentina » Tue Nov 19, 2013 1:43 pm

Thanks Dave,

I'm doing the same.

BTW: What character are you using as record separator ? [#13]? [#10]? another one ?

Thanks in advance,
David de Argentina
User avatar
David de Argentina
 
Posts: 1553
Joined: Mon Apr 04, 2005 4:13 pm
Location: Buenos Aires, Argentina

Re: Transfering data from MySQL to MS Access...

Postby Neosoft Support » Wed Nov 20, 2013 11:31 am

The CSV file is a standard ASCII format so the line break should be CR+LF or [#13][#10].
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5593
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA


Return to PlugIn Discussions

Who is online

Users browsing this forum: No registered users and 1 guest