Weird SQL to MS-Access problem

[Anon]

Hello,

With phpMyAdmin I made a dump of a MySQL database... And now I'm trying to import all the queries in this dump into an empty MS-Access database.

The strange thing is that a command like this works perfectly:

CREATE TABLE animals (race int);

But when I make it into this:

CREATE TABLE animals (race int(4));

...it claims the instruction CREATE TABLE has a syntax error ('80040e14').

Anyone got a clue what I'm doing wrong?
I've got a headache.

[[deleted]]

Silly question: why would you want to change the datatype from int to int(4) if int works?

[Anon]

Well, it was int(4) originally.
I don't feel like manually removing every number between parentheses in an entire forum. 😛