By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,070 Members | 1,237 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,070 IT Pros & Developers. It's quick & easy.

import data MySql with Access from Excel file

P: n/a
i try to copy data from excel into my MySql database which runs on a
linux.

i use MS Access to access the database. i need to optain the unique id
number, and this is where i have some troubles.

how can i either insert data, so my unique id number is continuing

or, how can i access my MySql database with MS Access without a "Unique
Record Identifier"?

i can connect to it without the "Unique Record Identifier", but then i
can't update/work the database.

any help appreciated, I am a beginner.

cheers dimitri

Jan 26 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

When you connect to the MySQL DB you have to indicate the Primary Key
column(s) in the MySQL table, otherwise the table will not be updateable
by Access.

When you link to the MySQL table a prompt will appear asking for the
Primary Key column(s). Select the columns in the table that uniquely
identify the row.

You can also assign the PK to a linked table, after it has been linked,
with a DDL statement like this:

ALTER TABLE <table name> ADD CONSTRAINT <constraint name>
PRIMARY KEY (<column list>)

E.g.:

ALTER TABLE Accounts ADD CONSTRAINT PK_Accounts
PRIMARY KEY (account_no, region_no)

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQ9lAp4echKqOuFEgEQIcAACg9B/tJL8GGpnGOQDRSQh7GEx6Rl8AoM9E
58BFDD4mlHIMM9KYGD61oRyw
=DbWD
-----END PGP SIGNATURE-----
dimitri wrote:
i try to copy data from excel into my MySql database which runs on a
linux.

i use MS Access to access the database. i need to optain the unique id
number, and this is where i have some troubles.

how can i either insert data, so my unique id number is continuing

or, how can i access my MySql database with MS Access without a "Unique
Record Identifier"?

i can connect to it without the "Unique Record Identifier", but then i
can't update/work the database.

any help appreciated, I am a beginner.

cheers dimitri

Jan 26 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.