I am developing an application which use ADO with access. I have used the appAccess.TransferText method to import a csv file into a new table. Through the development i have decided not to use a specification in the statement. So it looks like this

.DoCmd.TransferText acImportDelim, , "tblTable1",gstrFilePathToOpen, True

Table1 does not exist already on the DB. But i am sure that the table should be created as i have had it doing this previoulsy. I am now recieving the following error when using this command. Any suggestions welcomed (an no i dont want to have the table their already).

Cheers

p.s I a using vb6 with Access 97