G
Greg
HI All
I have a a pile of txt files to import into access (200) each file has
stock information (share market) one of the problems i have is that that
each sto code is a seperate file but does not have the stock code with
each record.
I need to find a way on how to insert the stock code as it is imported
into access .
I have thought about opening the file doing an array for each file and
adding the extra field closing the file etc and then import the text
files into the required table.
If anyone has any better ideas i would be more than gratefull
Thanks in advance
Olly
I have a a pile of txt files to import into access (200) each file has
stock information (share market) one of the problems i have is that that
each sto code is a seperate file but does not have the stock code with
each record.
I need to find a way on how to insert the stock code as it is imported
into access .
I have thought about opening the file doing an array for each file and
adding the extra field closing the file etc and then import the text
files into the required table.
If anyone has any better ideas i would be more than gratefull
Thanks in advance
Olly