Use VBA to link a semi colon delmited csv file

[JazzSP8]

Hey All

I'm trying to use VBA to link a "csv" file as a table that has semi colons as a delimiter.

If I use 'External Data > New Data Source > From File > Text File' and set the semi colon as the delimeter then it links as I'd expect it to do.

I can get the file to link using VBA but all the data appears in one field.

I've been Googling around and apparantly I needed to create a "schema.ini" file to be able to use the semi colon as a delimiter, which I've tried to do but it doesn't seem to be working.

This is what I've got;

Sub FnB()

    Open CurrentProject.Path & "\schema.ini" For Output As #1
        Print #1, "[All Attributes.csv]"
        Print #1, "ColNameHeader=True"
        Print #1, "Format=Delimited(;)"
    Close #1
    
    DoCmd.TransferText TransferType:=acLinkDelim, TableName:="FnB", FileName:=CurrentProject.Path & "\All Attributes.csv", HasFieldNames:=True
    
End Sub

I've tried variations on a theme but I can't get it to work - The code above is what I think should work based on what I read but I seem to be missing something, somewhere.

Thanks for looking.

 

[JazzSP8]

Nevermind, the answer was there all along;

Import CSV file to an access table

Hello all, I would like to import an CSV file (see below) to an table in access with the command below. I only get one field name in the table with the name: Header1;Header2. How can I get two field name: Header1 and Header2? /P Command ======== DoCmd.TransferText _...

www.mrexcel.com

Thanks from the future, @smozgur

 

[smozgur]

Thanks from the future, @smozgur

Nice to hear it helps, and thanks for the feedback!