importing text files 1

[roamer762]

Hello,
I have a text directory into which a number of text files is imported daily. The files name vary from day to day.Is it possible to import all file by coding because as far as I know in the transfertext method you have to name the file .For me this is impossible as file name is not the same...however the directory into which they are saved is always the same (C:/temp/text)


Please help!!

 

[KenReay]

Hi

USe the DIR() function to return the file names on by one, roughly like so:

Dim strFilename as String

strFileName = Dir("C:/temp/text\*.*&quot
Do Until strFileName
doCmd.TransferTExt, ...etc
Dir
Loop

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[roamer762]

thanks a lot for your quick response!!

 

[KenReay]

Hi

OOPS should have said

Do Until strFileName = ""
Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK