How to actualize an access table with a csv-data?

Hi,

I have to actualize an access table with the content of a csv-data.

How can I automatically "import" the content of the csv-data in the access table?

Many thanks in advance!

Have a nice day
inversojvoAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Access has several builtin options using File - External Data. In most cases, if you must first examine the data (either manually or through code) you should import into a temporary table. From there, you can examine it, and then use the full strenght of VBA and SQL to manage the move to live tables.
0
 
peter57rCommented:
'actualize'  ?   Good grief!  I'm really old!
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I stumbled on that as well. I assume they meant to move data into the Access database ...
0
 
AccessYourBiz_ComCommented:
Use the menu File --> Get External Data --> Link Tables --> and change the File Type to CSV. Complete the wizard and then you will have a link to your csv file. Then Create a new "Append" query based upon this new linked csv file and append it to your target table. If you regularly get new csv files you can add the new data by re-running the query.
0
 
inversojvoAuthor Commented:
Many thanks !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.