Extraction of a certain field from text files

  • Thread starter Thread starter little_rascals
  • Start date Start date
L

little_rascals

Hi, I do not really have a good knowledge of reading and understandin
codes. Therefore, I seriously need some help here!!

First of all, I have this access database which consists of 6 differen
tables. The fields in these 6 tables do not consist of any primary key
and the 6 tables do not have any relationships. Is it advisable to us
Microsoft Access in this case when the 6 tables are not able to for
any relationships because they are not related to each other in an
way??

The data in the 6 tables come from importing of data from 6 differen
text files. I am able to import those data from the text files into th
various tables. However, in each text file, there is a heading whic
includes the text file title and the date. I do not need to import th
title of the text file but i need the date to be imported into th
tables as well. Can anyone tell me how i can extract the date from th
text file to be input into 1 of the fields in the table in Acces
database?
 
little_rascals said:
First of all, I have this access database which consists of 6 different
tables. The fields in these 6 tables do not consist of any primary keys
Click to expand...

.... in that case they are not tables ...
and the 6 tables do not have any relationships. Is it advisable to use
Microsoft Access in this case
Click to expand...

Not possible to say, without some information about what you intend to do
with these text files. Format and sort them for printing -- what about
Word? Select and filter them individiually -- what about Excel? Make pretty
graphs or carry out extensive stats analysis -- I'd use SPSS or MiniTab.
Carry out repetitive analysis which has to be quick and robust -- probably
hire someone good with PERL.

Access is good for (a) complex data modelling, i.e. multirelations and
strong validation checking and for (b) sophisticated security requirements.
Apart from that it has a medium-ish report writer, but loses hand over fist
to the dedicated programs as above.
However, in each text file, there is a heading which
includes the text file title and the date. I do not need to import the
title of the text file but i need the date to be imported
Click to expand...

This will require a little bit of VBA coding but should not be too bad.

Hope that helps


Tim F
 
Back
Top