Importing a Text File into a form

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

Hi,

I am building a forms application for a user. One of
the functions I need is to have the user import a text
file into the application and create an Access table.
The data in the text file would change but would be
called the same thing and be in the same location every
time. I would want the old table to be written over by
the new table as part of the application without getting
a pop up message asking me to confirm. What is the best
way to front end this whole process with a form?

Thanks,

Chuck
 
First of all inorder to do text import you need to create
a Import Specification, you can do that by just import
that patricular file for that patricular directory in the
desired table you want, then before you finish importing
the file there will be a advance button in the import
wizard click that and save the specification. Then if you
go to create a macro, Choose Transer Text, in that choose
specification you just saved, the Table name , File Name
with directory, whether the text file has field names or
not and then save the macro. Every time you run the macro
or you set it up to run automatically when you open the db
it import the text file and append it to the existing
table. Hope it helps
 
Back
Top