import csv into access table

User avatar
sal21
PlatinumLounger
Posts: 4334
Joined: 26 Apr 2010, 17:36

import csv into access table

Post by sal21 »

I need to import into access table a csv ; delimited.
But i dont need all value from csv, but the only value from column 1, column 7 column 10 and column 12, in filed1, filed4, filed 6 and filed 10

if is possible with ADO and vb6

User avatar
HansV
Administrator
Posts: 78235
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: import csv into access table

Post by HansV »

See if you can adapt the code from Append CSV file to existing Access table
Best wishes,
Hans