Read and import a Csv file

[gstylianou]

Hi all,

I would like to have the help of the most experienced of you to be able to read and import data from an Csv file into a new table in my access database. I have tried some methods but unfortunally i cannot do that

Attached you can find both the Csv file and my database.I will apprechiate if anyone can directly modify my example

Thank you in advanced

 

[gemma-the-husky]

import a csv

do it manually with the external data wizard.

when you understand the options, you can automate it with

docmd.transfertext ….