Once you get the import working using the wizards, you can save an import specification and use it for you next DoCmd.TransferText as outlined by Jacot-Descombes. Introduction to importing and exporting data - Applies to: Microsoft Access 2010 You need to choose External data from the menu, select your file and step through the wizard.Ībout importing and linking data and database objects - Applies to: Microsoft Office Access 2003 It is possible to import a text file manually into MS Access and this will allow you to choose you own cell delimiters and text delimiters. ''Start at line 3 and end at last line -1ĭoCmd.TransferText acImportDelim,, 'NewCSV', sFileOut, False

Set tsOut = fs.CreateTextFile(sFileOut, True) ''Overwrite Set tsIn = fs.OpenTextFile(sFileIn, 1) ''ForReading Set fs = CreateObject('Scripting.FileSystemObject') Furthermore, Access is limited to 255 columns, and a CSV is not, so there is no guarantee this will work Sub StripHeaderAndFooter()ĭim tsIn As Object, tsOut As Object ''TextStreamĭim sFileIn As String, sFileOut As String You refer to Excel CSV, which does not exists, and you show space delimited data in your example.

Your file seems quite small (297 lines) so you can read and write them quite quickly.

Import vcf into excel