Help!

[Peter Jung]

Hi there!

I'm sure you get a lot of these. . .

I'm trying to upload a table from Microsoft Access 2000 to MySQL using TDX
mysql Driver connect, my user name is craven2, so is the name of the
database ---I have the fields as follows:

Windows DSN name: craven2
MySQL host:  199.227.124.195
MySQL database name:  craven2
User:  craven2
Password:  xxxxxxxx
Port: (leaving blank)
SQL command on connect: craven2

None of the options are checked.

. . . and I'm receiving the following error:
[TCX][MyODBC]You have an error in your SQL syntax near [craven2' at line 1
(#1064)

Any idea what I'm doing wrong?

I'll be more than happy to send you $$$ for your help or promote you on my
site---you're doing everyone a great service by providing your
expertise---you deserve to be recognized.

I appreciate it,
Thx