Hi,

I want to import into an MDB table a csv file.

I'm trying to use the bulk copy table.

my function is:

SQL = "SELECT * INTO [my_table] FROM [ODBC;Driver=Micrsoft text driver (*.txt; *csv) ;Dbq=c:\\;Extensions=asc,csv,tab,txt;].table.csv"

db.OpenEx( "Driver=Microsoft Access Driver .mdb);DBQ=c:\\access.mdb;", CDatabase::noOdbcDialog );

db.ExecuteSQL( SQL );

when i run this function i get an error : "You cannot use ODBC to import from, export to, or link an external Microsoft Jet or ISAM database table to your database"

when i try to import in the same way a dbf file (insted the csv file) with VFP it's working well.

what seems to be the problem? how can i fix it? or if some one know how can i import a large csv file into access DB in an efficient diffrent way?

thanks ishay