M
me
I try to save data from a .csv file into an Access database but if I follow
the documentation with the syntax
FROM tableexpression IN {path | ["path" "type"] | ["" [type; DATABASE =
path]]}
I always get the error message
"Syntax error in FROM clause."
I use the following SQL Statement:
SELECT
[field1]
,[field2]
,[field3]
,[field4]
,[field4]
FROM Table IN
"Path"
Questions:
What is the table name in a .csv file?
What is the table name in a .xls file? I tried the worksheet name as
suggested in the documentation. But this does not work!
How do I specify the path?
Why do I also get the error message if I specify a .mdb file? This should
work.
Thank you very much.
the documentation with the syntax
FROM tableexpression IN {path | ["path" "type"] | ["" [type; DATABASE =
path]]}
I always get the error message
"Syntax error in FROM clause."
I use the following SQL Statement:
SELECT
[field1]
,[field2]
,[field3]
,[field4]
,[field4]
FROM Table IN
"Path"
Questions:
What is the table name in a .csv file?
What is the table name in a .xls file? I tried the worksheet name as
suggested in the documentation. But this does not work!
How do I specify the path?
Why do I also get the error message if I specify a .mdb file? This should
work.
Thank you very much.