Extraction of a certain field from text files

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?
 

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

Top