import from access

[PhillipH]

Im trying to import a database/tables from a microsoft database but im having problems. I dont understand why its asking for a dns name, and my database isnt in the tables list.

any help? thanks

Phillip

ASP Coder

http://www.aspcoder.co.uk

[peterlaursen]

you must configure an ODBC-instance! (from “administrative tools” in control panel)

If you want to IMPORT from Ms-Access using Sqlyog's “powertools” it must be an instance of the Microsoft Driver for Access. It could be a “system-DSN” or “user-DSN” and should point to the Access databasefile.

If you want to EXPORT from MS-Access, the ODBC-driver to configure must be the ODBC-driver for MySQL, that you can get from http://www.mysql.com. And it must be configured with a “connection string” (server-URL, User and password) that describes the MySQL-connection

MySQL also has an ODBC-import-tool. Never tried it because it crashes on my computer!

Using Sqlyog and importing from here is more flexible than exporting from Access. When the Access-driver is correctyly configured the name of the ODBC-instance will be visible in the drop-down-box in the Sqlyog ODBC-import wizard.

Are you sure you understand ODBC ?

[sne]

I'm trying to import data from access /cyrilic data CHARSET cp1251/, but a problem occured /only ????????? can be seen/.

Pls kindly advise if this is possible and “what” option-s I have to change in order to transfer data correctly.

Sorry for troubles

Best rgds

[peterlaursen]

@ sne

what are

1) the MySQL-version ?

2) the storage engine ?

3) the default charset (and collation if it applies) of the MySQl server ?

I know nothing in particular about cyrillic charsets, but instead of importing directly you might save as an sql-file and edit it with a text-editor and insert somthing like “ENGINE=MyISAM DEFAULT CHARSET=latin1”

it should ocur here

…

…

`last-row` mediumtext,

PRIMARY KEY (`myPk`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `mp3_filer` */

insert into …..

What does the .sql-file look like, when you open it ??

Can you enter data from the keyboard OK ?

You could also try exporting from Access. Does that give the same result ?

[sne]

@peterlaursen,

Thanks a lot!

There was a mistake in configuration SQL Server.

Now all is OK!

[Author]

Posts