IN Clause with .csv, .xls and .mdb

[Guest]

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.

 

[Arvin Meyer [MVP]]

Your brackets are wrong for a path:

SELECT * FROM [S:\Current\Data.mdb].tblAddresses;

 

[Guest]

Thanks a lot, Arvin.

Your brackets are wrong for a path:

SELECT * FROM [S:\Current\Data.mdb].tblAddresses;
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

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.