Program form to read .csv file

  • Thread starter Thread starter Jean
  • Start date Start date
J

Jean

Hi,

I'm working on a project, and was wondering if the
following is possible, and if I'm not maybe dreaming :)

I want to design a form, which the user opens and then has
the option of specifying a .csv file. This file is then
used to import data into a table. Of course, I know this
is relatively easy to do in Access with the rightclick ->
Import funtion, but is there a way to program this to be
done at run-time, where the data will also be stored in
the correct fields etc.?

Any pointers in the right direction, is much appreciated.

Jean
 
you can use
DoCmd.TransferText with a predefined layout
see the Access help for more info
 
Back
Top