I wish to ask a question on the usage of the DoCmd.TransferText statement.

I have a data text file to import:

Public Sub DataImport(myDataFile As String, myDatabase As String)
Dim accApp As Access.Application
Set accApp = New Access.Application
accApp.OpenCurrentDatabase App.Path + "\database\" + myDatabase, True
accApp.DoCmd.TransferText acImportDelim, , "Temp", App.Path + "\datafiles\" + myDataFile, True
accApp.Quit
Set accApp = Nothing
End Sub

I just leave the specificationName to blank for default format. But some rows of the data like

0049;NEW ASAI "A";02/05/2001;0.0;1.93;1.92;1.92;477950

becomes 0049;NEW ASAI

and "Unparsable Record" is shown in the DataFile_ImportErrors table.

,and all the whole rows of data are is treated as one column after import.

Obviously the problem is due to the " character. How can I solve this problem?

Also can I and how to create a schema.ini file for customizing the data format of the file being imported?