automating import of csv

[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

 

[Joe Delphi]

Check the TransferText command or other Transfer... commands.

JD

 

[Van T. Dinh]

Check Access VB Help on the TransferText Method.

HTH
Van T. Dinh
MVP (Access)