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?
