Import csv file into existing access table using VBA

Question

Hi i have a quick question what is the VBA code that will allow me to import a CSV file into a existing table in Access 2010 with its own field names?

Thanks

msdn.microsoft.com/en-us/library/office/ff835958.aspx

litelite
– litelite

2016-06-22 13:06:00 +00:00
Commented Jun 22, 2016 at 13:06 — litelite
– litelite, Commented Jun 22, 2016 at 13:06

Traceur · Accepted Answer · 2016-06-22 13:05:53Z

4

this should work

DoCmd.TransferText TransferType:=acLinkDelim, TableName:="tblImport", _
        FileName:="C:\MyData.csv", HasFieldNames:=true

answered Jun 22, 2016 at 13:05

Traceur

5312 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Traceur Over a year ago

np, if you could 'accept' my answer, that'd be nice :)

Tony Over a year ago

Because you use acLinkDelim it only links the file to Access, it does not import the data. You need to use acImportdelim

Collectives™ on Stack Overflow

Import csv file into existing access table using VBA

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related