Visual Basic / Access Question

[imspartacus]

Hi

I'm trying to load an excel .csv file into access through a vb program I'm writing. The relevant code is as follows :

Set db = OpenDatabase("c:dellsecdellsec.mdb")
sqlStr = "load from '" & activefile & "' insert into csv_imp"
Set rs = db.OpenRecordset(sqlStr)

The sqlStr string is :
"load from 'C:dellsecFCC000061_20030114.csv' insert into csv_imp"

Once the "Set rs = " line is processed I get an error saying that the JET DB engine cant find the table or query. The table is in the db so I'm thinking there's a problem with the SQL. Does Access support "Load from" in SQL ? "LOAD" doesn't appear to be a reserved word. Heeeeeeeeeelp.

 

[Tanis]

The command to use is TransferText. Have a look at the help file for more info.

DoCmd.TransferText acImportDelim, , "TableName", "PathnameFilename.csv", True

David