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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access import CSV file with comma issue 4
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Access Importing csv daily files into access 2007 1
Import files into access 1
subform to change from combo with csv source 1
CSV import into table not working...? 1
Create a csv file 11
Import CSV file and add data to records 3

Back
Top