Importing file name index.csv with adodb error

[jaryszek]

Hi Guys,

i have issues with importing "Index.csv" file name.
(in attachment).

Code to import this file:

Please Login or Register  to view this content.

getting error "SYNTAX error in FROM clause".

When i am changing this file name to "Index2.csv" it is read without any issues!
Why?

Please help,
Jacek

[Arkadi]

I assume it is one of those words that you can't use in the name because it is reserved? since you are just selecting all, you could open it, copy the contents and then close it again, but I don't think you can do this with an SQL statement.

[romperstomper]

Use square brackets:

Please Login or Register  to view this content.

also note that fields are indexed starting at 0 not 1.

[Arkadi]

Oops, didn't think of that... good call rorya

[jaryszek]

Hmm interesting, thank you.

Why with square brackets is working and why without not? Is really index reserved word?

best,
Jacek

[romperstomper]

It is in SQL generally (used for creating indices) so I would assume it is with the ACE OLEDB provider.

[jaryszek]

hmm interesting, i mean it is first time when i have problem with reading CSV and i am importing about 40 tables into my workbook.

Anyway,
thank you for help,
Jacek

[romperstomper]

It is always safer to put field names and table names in square brackets.

[jaryszek]

Thanks, lesson learned.

Best,
Jacek