Import CSV file into access db

[Joost]

Hi,

I have a csv file with 2 records (each record has 5 values seperated
with a ";"). Now I have an asp file with the following code:

---
Dim csv_path
csv_path = Server.MapPath("./") & "\"

SQL = "SELECT * INTO table FROM [csv_file.csv] IN """ & csv_path &
""" ""TEXT;"""

'SQL = "INSERT INTO table SELECT * FROM [csv_file.csv] IN """ &
csv_path & """ ""TEXT;"""

objConn.Execute SQL
---

But now all the values of one record are put into one field of the
table (and not in 5 seperated fields). How can I fix this problem?

Thanks in advance!
Joost