automating import of csv

M

Martin Payne

Hi all,

I have a process for which I need to import a csv file. I am currently
executing the process manually but, as it is repetitive, I am
interested in automating it.

I've had a look at the macro actions and it doesn't appear that any are
tailored for my needs. So, it looks like I will be writing a module.

Now, just to set things straight, I have quite a bit of experience
writing modules for access. I just need to know - is there an easy
approach to achieving my above stated goal (import a csv), or do I need
to write code for opening the input file and parsing each line?

Cheers
Martin
 
V

Van T. Dinh

Check Access VB Help on the TransferText Method.

HTH
Van T. Dinh
MVP (Access)
 
Top