MySQL and Excel

**Miguel61** · Sep 16, 2009, 02:06

Hi everyone;

In the old db access I use this query for insert values in the file excel:

Code:

INSERT INTO [SHEET$] (A, B, C) VALUES (1, 2, 3)

In the new db mysql this query not working... why?
Can you help me ?

**r937** · Sep 16, 2009, 02:55

Originally Posted by Miguel61

In the new db mysql this query not working... why?

because mysql does not use square brackets to delimit problematic table/column names

Code:

INSERT INTO `SHEET$` (A, B, C) VALUES (1, 2, 3)

**Miguel61** · Oct 10, 2009, 06:03

Many thanks!

User Tag List