Extract data frm Text File

  • Thread starter Thread starter SeRene
  • Start date Start date
S

SeRene

Hello,

I have this text file which consists of a header and body
part.

The header includes the title of the text file data, for
example, Customer's Purchases and a date. The body part of
the text file consists of all the information.

I manage to import the body part into my Access table,
however, it is the date in the header part which i need
help with!!!

Can somebody tell me how i can actually "pull out" the
date in the header part and populate the date into the
Access table together with all the records which have been
imported on that particular day. I.e. there will be an
additional field, "Date" in the table along with the other
fields found in the body part of the text file. The date
appearing in the text file is supposed to be in the Access
table matching the records in the body part.
 
You'll need to do it in 2 steps. Pick up the date first,
then hold it in a public variable e.g., and you can then
include a public function that pulls it in for each
record added wit the data from the body of your
document. j.
 
Hi Jennifer,

I am able to get the first part. I can pick up the date
by "storing" it in the input box. However, it's the second
part that is bugging me. I am not sure how to go about
doing the second part. Can you kindly give me some
guidance on Access codes?
Thanks!
 
Back
Top