Processing Text file and updating in MS Access DB?

  • Thread starter Thread starter anandhan.natarajan
  • Start date Start date
A

anandhan.natarajan

It is possible to read a data from Text file and do the processing in
MS Access? Basically i am having data in text file. I have to do some
kind of processing to get the data. I wanted to update the access
database using the processed data. Is it possible? If so how?
 
If the data is consistently laid out with one line for each record and
columns of a fixed width, or values separated by commas, you can either:
a) Attach the text file with:
File | Get External | Link
or
b) Import the data from a text file with:
TransferText
in a macro or code.

From there you will need to have some skills with queries and probably with
VBA to perform the processing of the data. You may need to import the data
into a temporary table, process it, and then append it to your real tables.
The process of actually doing that is bigger than a newsgroup question can
answer.
 
Back
Top